/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : localhost
 Source Database       : tuina

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : utf-8

 Date: 08/30/2021 00:10:05 AM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `eb_banner`
-- ----------------------------
DROP TABLE IF EXISTS `eb_banner`;
CREATE TABLE `eb_banner` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cover` varchar(255) DEFAULT '' COMMENT '图片地址对象（key,pic）',
  `title` varchar(120) DEFAULT '' COMMENT 'banner描述',
  `link` varchar(255) DEFAULT '' COMMENT '跳转地址',
  `school_id` int(10) unsigned DEFAULT '0' COMMENT '校区ID',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '机构ID',
  `is_del` int(10) unsigned DEFAULT '0',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '是否显示的状态',
  `banner_sort` smallint(5) unsigned DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mix` (`school_id`,`org_id`,`is_del`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='轮播图';

-- ----------------------------
--  Records of `eb_banner`
-- ----------------------------
BEGIN;
INSERT INTO `eb_banner` VALUES ('5', '{\"pic\":\"https:\\/\\/ks3-cn-beijing.ksyun.com\\/teaseyoulearn\\/label_icon\\/1621502590176.png\",\"key\":\"label_icon\\/1621502590176.png\"}', '1', 'https://study-center.dounixue.net/wap/course/index.html?id=40', '6', '1', '0', '1', '0'), ('6', '{\"pic\":\"https:\\/\\/ks3-cn-beijing.ksyun.com\\/teaseyoulearn\\/label_icon\\/1622022438713.jpg\",\"key\":\"label_icon\\/1622022438713.jpg\"}', '超值体验', 'https://study-center.dounixue.net/wap/course/index.html?id=14', '7', '1', '0', '1', '0'), ('7', '{\"pic\":\"https:\\/\\/ks3-cn-beijing.ksyun.com\\/teaseyoulearn\\/label_icon\\/1623902152077.jpg\",\"key\":\"label_icon\\/1623902152077.jpg\"}', '初中英语综合提升', 'https://study-center.dounixue.net/wap/course/index.html?id=63', '13', '3', '0', '1', '0'), ('8', '{\"pic\":\"https:\\/\\/ks3-cn-beijing.ksyun.com\\/teaseyoulearn\\/label_icon\\/1624528297784.png\",\"key\":\"label_icon\\/1624528297784.png\"}', '新初三语文', 'https://study-center.dounixue.net/wap/course/index.html?id=48', '12', '2', '0', '1', '0'), ('9', '{\"pic\":\"https:\\/\\/ks3-cn-beijing.ksyun.com\\/teaseyoulearn\\/label_icon\\/1624859037642.jpg\",\"key\":\"label_icon\\/1624859037642.jpg\"}', '初中英语综合提升班', 'https://study-center.dounixue.net/wap/course/index.html?id=40', '6', '0', '0', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `eb_bought_package`
-- ----------------------------
DROP TABLE IF EXISTS `eb_bought_package`;
CREATE TABLE `eb_bought_package` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned DEFAULT '0' COMMENT '订单ID',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `pck_id` int(10) unsigned DEFAULT '0' COMMENT '套餐ID',
  `pck_name` varchar(120) DEFAULT '' COMMENT '冗余套餐名称',
  `expire_type` tinyint(1) unsigned DEFAULT '0' COMMENT '过期类型【1：永久有效 2：指定日期有效】',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间【expire_type为2时有值】',
  `valid_type` tinyint(1) unsigned DEFAULT '0' COMMENT '有效类型【1：单项计次 2：整体计次 3：不限次数】',
  `valid_nums` mediumint(6) unsigned DEFAULT '0' COMMENT '有效次数（valid_type为2获1整体计次、单项计次时有值）',
  `bought_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '购买价',
  `used_nums` smallint(6) unsigned DEFAULT '0' COMMENT '已用次数(套餐整体使用次数，非子项累加数)',
  `status` tinyint(1) unsigned DEFAULT '0' COMMENT '状态【1：正常有效】',
  `create_time` datetime DEFAULT NULL COMMENT '购买时间',
  `last_used_time` datetime DEFAULT NULL COMMENT '最后使用时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mix` (`uid`,`pck_id`) USING BTREE,
  KEY `oid` (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户已购表';

-- ----------------------------
--  Table structure for `eb_bought_package_items`
-- ----------------------------
DROP TABLE IF EXISTS `eb_bought_package_items`;
CREATE TABLE `eb_bought_package_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bought_id` int(10) unsigned DEFAULT '0' COMMENT '购买ID',
  `pck_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '套餐ID',
  `rel_type` varchar(10) DEFAULT '' COMMENT '关联类型【goods:商品 service:服务】',
  `rel_id` int(10) unsigned DEFAULT '0' COMMENT '关联ID',
  `rel_name` varchar(120) DEFAULT '' COMMENT '关联实体的名称（冗余）',
  `valid_nums` mediumint(8) DEFAULT NULL COMMENT '有效次数（valid_type为1单项计次时有值）',
  `price` decimal(10,2) unsigned DEFAULT '0.00',
  `used_nums` mediumint(8) unsigned DEFAULT '0' COMMENT '已用次数',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mixed` (`rel_type`,`rel_id`) USING BTREE,
  KEY `pck` (`pck_id`) USING BTREE,
  KEY `m2` (`bought_id`,`pck_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='套餐包内容';

-- ----------------------------
--  Table structure for `eb_bought_service`
-- ----------------------------
DROP TABLE IF EXISTS `eb_bought_service`;
CREATE TABLE `eb_bought_service` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(10) unsigned DEFAULT '0' COMMENT '订单ID',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `rel_type` varchar(10) DEFAULT NULL COMMENT '关联类型【goods:商品 service:服务】',
  `rel_id` int(10) unsigned DEFAULT '0' COMMENT '关联的商品或服务ID',
  `bought_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '购买价',
  `used_nums` smallint(5) unsigned DEFAULT '0' COMMENT '已用次数',
  `status` tinyint(1) unsigned DEFAULT '0' COMMENT '状态【1：正常有效】',
  `create_time` datetime DEFAULT NULL COMMENT '购买时间',
  `last_used_time` datetime DEFAULT NULL COMMENT '最后使用时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE,
  KEY `oid` (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户已购表';

-- ----------------------------
--  Table structure for `eb_card_log`
-- ----------------------------
DROP TABLE IF EXISTS `eb_card_log`;
CREATE TABLE `eb_card_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `order_id` int(10) unsigned DEFAULT '0' COMMENT '订单ID',
  `card_level` tinyint(2) unsigned DEFAULT '0' COMMENT '卡等级',
  `now_money` decimal(14,2) unsigned DEFAULT '0.00' COMMENT '实收金额',
  `gift_money` decimal(14,2) unsigned DEFAULT NULL COMMENT '赠送金额',
  `act_type` tinyint(1) unsigned DEFAULT '0' COMMENT '操作类型【1：开卡 2：升级 3：退卡】',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '所属机构',
  `school_id` int(10) unsigned DEFAULT '0' COMMENT '所属分店',
  `is_del` int(10) unsigned DEFAULT '0' COMMENT '删除标志',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `oid` (`order_id`) USING BTREE,
  KEY `mix` (`org_id`,`school_id`,`is_del`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='会员卡操作记录';

-- ----------------------------
--  Records of `eb_card_log`
-- ----------------------------
BEGIN;
INSERT INTO `eb_card_log` VALUES ('1', '1', '1', '2', '5000.00', '500.00', '1', '2021-08-29 23:09:07', '', '1', '7', '0');
COMMIT;

-- ----------------------------
--  Table structure for `eb_category`
-- ----------------------------
DROP TABLE IF EXISTS `eb_category`;
CREATE TABLE `eb_category` (
  `id` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
  `cate_name` varchar(120) DEFAULT '' COMMENT '类别名称',
  `type` tinyint(3) unsigned DEFAULT '0' COMMENT '类型，支持扩展：（1:套餐 2：服务 3：商品）',
  `org_id` int(10) unsigned DEFAULT '0',
  `school_id` int(10) unsigned DEFAULT '0',
  `is_del` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mix` (`org_id`,`school_id`,`is_del`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='分类表';

-- ----------------------------
--  Records of `eb_category`
-- ----------------------------
BEGIN;
INSERT INTO `eb_category` VALUES ('1', '提神', '1', '1', '7', '0'), ('2', '饮料', '3', '1', '7', '0'), ('3', '香烟', '3', '1', '7', '0'), ('5', '养生胡子', '2', '1', '7', '0'), ('6', '提神', '2', '1', '7', '0');
COMMIT;

-- ----------------------------
--  Table structure for `eb_common_detail`
-- ----------------------------
DROP TABLE IF EXISTS `eb_common_detail`;
CREATE TABLE `eb_common_detail` (
  `rel_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关联ID',
  `rel_type` varchar(10) NOT NULL DEFAULT '' COMMENT '关联类型【goods:商品 service:服务 package:套餐】',
  `detail` text COMMENT '详情内容',
  PRIMARY KEY (`rel_id`,`rel_type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='详情通用表';

-- ----------------------------
--  Records of `eb_common_detail`
-- ----------------------------
BEGIN;
INSERT INTO `eb_common_detail` VALUES ('1', 'goods', ''), ('1', 'package', '&lt;p&gt;累了困了，不要喝东鹏特饮，现在都喝红牛&lt;/p&gt;'), ('1', 'service', '&lt;p&gt;some service details&lt;/p&gt;'), ('2', 'goods', ''), ('2', 'package', '&lt;p&gt;七夕健康养生套餐B详情&lt;/p&gt;'), ('2', 'service', '&lt;p&gt;时间萨斯的机会肯定是坎坷经历的第&lt;/p&gt;'), ('3', 'goods', ''), ('3', 'service', '&lt;p&gt;MiniUI - 专业WebUI控件库&lt;/p&gt;'), ('4', 'service', ''), ('5', 'service', '&lt;div class=&quot;index-module_textWrap_3ygOc&quot; style=&quot;max-width: 100%; overflow-x: visible; line-height: 24px; color: rgb(51, 51, 51); font-family: arial; white-space: normal; background-color: rgb(255, 255, 255);&quot;&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;浙江省委常委、杭州市委书记周江勇涉嫌严重违纪违法，目前正接受中央纪委国家监委纪律审查和监察调查。&lt;/p&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;br/&gt;&lt;/p&gt;&lt;/div&gt;&lt;div class=&quot;index-module_textWrap_3ygOc&quot; style=&quot;max-width: 100%; overflow-x: visible; line-height: 24px; color: rgb(51, 51, 51); margin-top: 22px; font-family: arial; white-space: normal; background-color: rgb(255, 255, 255);&quot;&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;br/&gt;&lt;/p&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;span style=&quot;max-width: 100%; color: rgb(0, 0, 0);&quot;&gt;&lt;strong style=&quot;max-width: 100%;&quot;&gt;周江勇简历&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;br/&gt;&lt;/p&gt;&lt;/div&gt;&lt;div class=&quot;index-module_textWrap_3ygOc&quot; style=&quot;max-width: 100%; overflow-x: visible; line-height: 24px; color: rgb(51, 51, 51); margin-top: 22px; font-family: arial; white-space: normal; background-color: rgb(255, 255, 255);&quot;&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;br/&gt;&lt;/p&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;周江勇，男，1967年9月生，汉族，浙江宁波人，1985年8月参加工作，1992年11月加入中国共产党，省委党校研究生，工商管理硕士。&lt;/p&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;br/&gt;&lt;/p&gt;&lt;/div&gt;&lt;div class=&quot;index-module_textWrap_3ygOc&quot; style=&quot;max-width: 100%; overflow-x: visible; line-height: 24px; color: rgb(51, 51, 51); margin-top: 22px; font-family: arial; white-space: normal; background-color: rgb(255, 255, 255);&quot;&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;br/&gt;&lt;/p&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;曾任共青团鄞县县委常委、副书记，宁波市民政局政治处主任助理（挂职）；共青团鄞县县委书记；鄞县鄞江镇党委书记、人大主席；鄞县副县长；宁波市鄞州区副区长；象山县委副书记、代县长、县长；象山县委书记；宁波杭州湾新区开发建设管委会主任、象山县委书记；宁波杭州湾新区开发建设管委会主任、党工委书记；宁波市委常委、宁波杭州湾新区开发建设管委会党工委书记；舟山市委副书记、代市长、市长，浙江舟山群岛新区党工委副书记、管委会常务副主任；舟山市委书记、市长，浙江舟山群岛新区党工委书记、管委会主任，浙江省海洋港口发展委员会（筹）副主任（兼）；舟山市委书记，浙江舟山群岛新区党工委书记、管委会主任，浙江省海洋港口发展委员会副主任（兼）；温州市委书记；浙江省委常委、温州市委书记；浙江省委常委、杭州市委书记等职。&lt;/p&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;br/&gt;&lt;/p&gt;&lt;/div&gt;&lt;div class=&quot;index-module_textWrap_3ygOc&quot; style=&quot;max-width: 100%; overflow-x: visible; line-height: 24px; color: rgb(51, 51, 51); margin-top: 22px; font-family: arial; white-space: normal; background-color: rgb(255, 255, 255);&quot;&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;br/&gt;&lt;/p&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;党的十九大代表。&lt;/p&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;br/&gt;&lt;/p&gt;&lt;/div&gt;&lt;div class=&quot;index-module_textWrap_3ygOc&quot; style=&quot;max-width: 100%; overflow-x: visible; line-height: 24px; color: rgb(51, 51, 51); margin-top: 22px; font-family: arial; white-space: normal; background-color: rgb(255, 255, 255);&quot;&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;br/&gt;&lt;/p&gt;&lt;p style=&quot;margin-top: 0px; margin-bottom: 0px; padding: 0px; overflow-y: auto; max-width: 100%; line-height: 24px;&quot;&gt;&lt;span style=&quot;max-width: 100%;&quot;&gt;（总台央视记者 王莉 范月鸣）&lt;/span&gt;&lt;/p&gt;&lt;/div&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;');
COMMIT;

-- ----------------------------
--  Table structure for `eb_distribution_commission`
-- ----------------------------
DROP TABLE IF EXISTS `eb_distribution_commission`;
CREATE TABLE `eb_distribution_commission` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` int(10) unsigned NOT NULL COMMENT '用户id',
  `org_id` int(10) unsigned NOT NULL COMMENT '机构id',
  `type` int(11) NOT NULL DEFAULT '1' COMMENT '变动类型 1入账 2提现',
  `order_type` int(11) NOT NULL DEFAULT '0' COMMENT '订单类型 0- 1直推订单 2裂变订单',
  `order_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单id',
  `order_amount` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '订单金额',
  `commission` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '佣金金额',
  `balance` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `create_time` bigint(20) DEFAULT '0' COMMENT '提交时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='佣金金额变动记录';

-- ----------------------------
--  Table structure for `eb_distribution_config`
-- ----------------------------
DROP TABLE IF EXISTS `eb_distribution_config`;
CREATE TABLE `eb_distribution_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置id',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '机构id',
  `key` varchar(255) NOT NULL COMMENT '字段名称',
  `value` varchar(255) NOT NULL COMMENT '字段值',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='分销配置表';

-- ----------------------------
--  Table structure for `eb_distribution_order`
-- ----------------------------
DROP TABLE IF EXISTS `eb_distribution_order`;
CREATE TABLE `eb_distribution_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` int(10) unsigned NOT NULL COMMENT '用户id',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '机构id',
  `p_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级id',
  `relation_type` int(11) NOT NULL DEFAULT '1' COMMENT '订单关联类型 1课程报名',
  `relation_id` int(11) DEFAULT NULL COMMENT '关联id',
  `order_amount` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '订单金额',
  `actual_amount` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '实收金额',
  `commission` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '分销金额',
  `p_commission` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '上级分销金额',
  `platform_fee` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '平台抽成',
  `create_time` bigint(20) NOT NULL DEFAULT '0',
  `status` int(11) DEFAULT '1' COMMENT '状态,1正常 2已撤销',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='分销订单记录表';

-- ----------------------------
--  Table structure for `eb_distribution_separate`
-- ----------------------------
DROP TABLE IF EXISTS `eb_distribution_separate`;
CREATE TABLE `eb_distribution_separate` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `relation_id` int(10) unsigned DEFAULT NULL COMMENT '关联id',
  `relation_type` int(11) DEFAULT '1' COMMENT '关联类型 1课程',
  `senior_separate` double(16,2) DEFAULT '0.00' COMMENT '高级推广人分成',
  `senior_fission` double(16,2) DEFAULT '0.00' COMMENT '高级推广人裂变分成',
  `first_separate` double(16,2) DEFAULT '0.00' COMMENT '一星推广人分成',
  `second_separate` double(16,2) DEFAULT '0.00' COMMENT '二星推广人分成',
  `third_separate` double(16,2) DEFAULT '0.00' COMMENT '三星推广人分成',
  `is_open` int(11) DEFAULT '0' COMMENT '是否开启',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='推广分成设置表';

-- ----------------------------
--  Table structure for `eb_distribution_user`
-- ----------------------------
DROP TABLE IF EXISTS `eb_distribution_user`;
CREATE TABLE `eb_distribution_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` int(10) unsigned NOT NULL COMMENT '用户id',
  `org_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '机构id',
  `role_id` int(11) NOT NULL DEFAULT '1' COMMENT '用户身份（1，家长，2学生）',
  `mobile` varchar(13) DEFAULT NULL COMMENT '手机号',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT '推广人等级 (0高级 1一星 2二星 3三星)',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT '父级id',
  `balance` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `withdrawed_amount` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '已提现',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 1正常 0停用',
  `is_del` int(11) NOT NULL DEFAULT '0' COMMENT '是否删除',
  `total_com` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '佣金总额',
  `direct_com` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '直推佣金',
  `fission_com` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '裂变佣金',
  `total_order_amount` double(16,2) NOT NULL DEFAULT '0.00' COMMENT '售出订单总额',
  `create_time` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='推广用户表';

-- ----------------------------
--  Table structure for `eb_goods`
-- ----------------------------
DROP TABLE IF EXISTS `eb_goods`;
CREATE TABLE `eb_goods` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) DEFAULT '' COMMENT '商品名称',
  `price` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '售价',
  `original_price` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '原价',
  `cover` varchar(255) DEFAULT '' COMMENT '封面图',
  `is_rmt` tinyint(2) unsigned DEFAULT '0' COMMENT '推荐至前台',
  `cate_id` smallint(5) unsigned DEFAULT '0' COMMENT '分类ID',
  `status` tinyint(2) unsigned DEFAULT '1' COMMENT '状态',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '所属机构',
  `school_id` int(10) unsigned DEFAULT '0' COMMENT '所属分店',
  `is_del` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mix` (`org_id`,`school_id`,`is_del`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='商品表';

-- ----------------------------
--  Records of `eb_goods`
-- ----------------------------
BEGIN;
INSERT INTO `eb_goods` VALUES ('1', '营养快线', '4.50', '0.00', '[]', '0', '3', '1', '1', '7', '0'), ('2', '加多宝', '7.00', '0.00', '[]', '0', '2', '1', '1', '14', '0'), ('3', '软中华', '80.00', '0.00', '[]', '0', '3', '1', '1', '7', '0');
COMMIT;

-- ----------------------------
--  Table structure for `eb_hotsearch`
-- ----------------------------
DROP TABLE IF EXISTS `eb_hotsearch`;
CREATE TABLE `eb_hotsearch` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(120) DEFAULT '',
  `org_id` int(10) unsigned DEFAULT '0',
  `school_id` int(10) unsigned DEFAULT '0',
  `is_del` int(10) unsigned DEFAULT '0',
  `status` tinyint(2) unsigned DEFAULT '1',
  `sort` smallint(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mix` (`org_id`,`school_id`,`is_del`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `eb_hotsearch`
-- ----------------------------
BEGIN;
INSERT INTO `eb_hotsearch` VALUES ('1', '暑期', '1', '6', '0', '1', '1'), ('2', '函数', '1', '6', '0', '1', '2');
COMMIT;

-- ----------------------------
--  Table structure for `eb_order`
-- ----------------------------
DROP TABLE IF EXISTS `eb_order`;
CREATE TABLE `eb_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_no` varchar(30) DEFAULT '' COMMENT '订单编号',
  `out_trade_no` varchar(40) DEFAULT NULL COMMENT '外部交易订单号',
  `orgn_amt` decimal(14,2) unsigned DEFAULT '0.00' COMMENT '原始金额',
  `disc_amt` decimal(14,2) unsigned DEFAULT '0.00' COMMENT '折扣金额',
  `order_amt` decimal(14,2) DEFAULT '0.00' COMMENT '实际金额',
  `status` tinyint(5) unsigned DEFAULT '0' COMMENT '订单状态【1：正常有效】',
  `pay_type` tinyint(5) unsigned DEFAULT '0' COMMENT '支付方式【1微信支付,2支付宝支付,3现金,4会员卡】',
  `pay_status` tinyint(5) unsigned DEFAULT '0' COMMENT '支付状态【1已支付】',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '所属机构',
  `school_id` int(10) unsigned DEFAULT '0' COMMENT '所属分店',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `uid` int(10) unsigned DEFAULT '0' COMMENT '会员ID',
  `pub_aid` int(10) unsigned DEFAULT '0' COMMENT '提交管理员ID（后台开单时有值）',
  `is_del` int(10) unsigned DEFAULT '0',
  `order_type` tinyint(3) unsigned DEFAULT NULL COMMENT '订单类型【1：消费 2：充值 3：退款 4：开卡 5：升卡】',
  `refund_type` tinyint(1) unsigned DEFAULT '0' COMMENT '退款类型，order_type为3时有值【1：退卡 2：退套餐】',
  `platform` enum('backend','H5') DEFAULT 'backend' COMMENT '平台',
  `spread_uid` int(10) unsigned DEFAULT '0' COMMENT '推广人UID',
  `remark` varchar(255) DEFAULT '' COMMENT '订单备注',
  `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间',
  `last_update_at` varchar(40) DEFAULT '' COMMENT '最后更新人',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ono` (`order_no`) USING BTREE,
  KEY `mix` (`org_id`,`school_id`,`is_del`) USING BTREE,
  KEY `s1` (`order_type`,`uid`,`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='订单表';

-- ----------------------------
--  Records of `eb_order`
-- ----------------------------
BEGIN;
INSERT INTO `eb_order` VALUES ('1', 'UA202108292309077922', 'IO202108292309078090', '5000.00', '0.00', '5000.00', '1', '2', '1', '1', '0', '2021-08-29 23:09:07', '1', '10', '0', '4', '0', 'backend', '0', '', null, ''), ('2', 'UR202108292315593201', 'IO202108292315596939', '4000.00', '0.00', '4000.00', '1', '1', '1', '1', '7', '2021-08-29 23:15:59', '1', '10', '0', '2', '0', 'backend', '0', '充值4000送400', null, '');
COMMIT;

-- ----------------------------
--  Table structure for `eb_order_items`
-- ----------------------------
DROP TABLE IF EXISTS `eb_order_items`;
CREATE TABLE `eb_order_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bought_id` int(10) unsigned DEFAULT '0' COMMENT '已购ID',
  `order_id` int(10) unsigned NOT NULL COMMENT '订单ID',
  `pck_id` int(10) unsigned DEFAULT '0' COMMENT '套餐ID',
  `rel_type` varchar(10) DEFAULT NULL COMMENT '关联类型【goods:商品 service:服务】',
  `rel_id` int(10) unsigned DEFAULT '0' COMMENT '关联的商品或服务ID',
  `rel_name` varchar(120) DEFAULT '' COMMENT '关联名称',
  `price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '单价',
  `qty` smallint(6) unsigned DEFAULT '0' COMMENT '数量',
  `disc_amt` decimal(14,2) unsigned DEFAULT '0.00' COMMENT '折扣金额',
  `amt` decimal(14,2) unsigned DEFAULT '0.00' COMMENT '小项总价',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `oid` (`order_id`,`pck_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='订单明细项目';

-- ----------------------------
--  Table structure for `eb_organ`
-- ----------------------------
DROP TABLE IF EXISTS `eb_organ`;
CREATE TABLE `eb_organ` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `organ_no` char(13) DEFAULT '' COMMENT '机构编码（主要用以隐藏机构ID场景下使用）',
  `organ_name` varchar(150) DEFAULT '' COMMENT '机构名称',
  `organ_type` tinyint(3) unsigned DEFAULT '0' COMMENT '机构类型',
  `organ_contactor` varchar(40) DEFAULT '' COMMENT '机构联系人',
  `organ_phone` varchar(255) DEFAULT '' COMMENT '机构联系电话',
  `organ_address` varchar(255) DEFAULT '' COMMENT '机构地址',
  `organ_status` tinyint(3) unsigned DEFAULT '0' COMMENT '机构状态',
  `organ_balance` decimal(14,2) unsigned DEFAULT '0.00' COMMENT '机构资金余额',
  `is_del` int(10) unsigned DEFAULT '0',
  `platform_divide` double(16,2) DEFAULT '0.00' COMMENT '平台抽成比例',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ogn` (`organ_no`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `eb_organ`
-- ----------------------------
BEGIN;
INSERT INTO `eb_organ` VALUES ('1', '60D5504E524EF', '逗你学', '2', '史进', '13611593654', '江苏南京雨花台软件大道', '1', '4.97', '0', '5.00'), ('2', '60D550664EA91', '悠悠语文', '1', '瑞瑞老师', '17887285621', '无', '1', '19619.40', '0', '5.00'), ('3', '60D550B79DD41', '圆源工作室', '1', '陆老师', '15601716937', '未知', '1', '148.56', '0', '5.00'), ('4', '60D550C299673', '米安工作室', '1', '米安', '13811365485', '江苏南京', '1', '0.00', '0', '5.00');
COMMIT;

-- ----------------------------
--  Table structure for `eb_package`
-- ----------------------------
DROP TABLE IF EXISTS `eb_package`;
CREATE TABLE `eb_package` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) DEFAULT '' COMMENT '商品名称',
  `price` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '售价',
  `original_price` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '原价',
  `cover` varchar(255) DEFAULT '' COMMENT '封面图',
  `is_rmt` tinyint(2) unsigned DEFAULT '0' COMMENT '推荐至前台',
  `status` tinyint(2) unsigned DEFAULT '1' COMMENT '状态',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '所属机构',
  `school_id` int(10) unsigned DEFAULT '0' COMMENT '所属分店',
  `is_del` int(10) unsigned DEFAULT '0',
  `expire_type` tinyint(1) unsigned DEFAULT '0' COMMENT '过期类型【1：永久有效 2：指定日期有效】',
  `expire_time` datetime DEFAULT '0000-00-00 00:00:00' COMMENT '过期时间【expire_type为2时有值】',
  `valid_type` tinyint(1) unsigned DEFAULT '0' COMMENT '有效类型【1：单项计次 2：整体计次 3：不限次数】',
  `valid_nums` mediumint(8) unsigned DEFAULT '0' COMMENT '有效次数（valid_type为2整体计次时有值）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mix` (`org_id`,`school_id`,`is_del`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='套餐表';

-- ----------------------------
--  Table structure for `eb_package_items`
-- ----------------------------
DROP TABLE IF EXISTS `eb_package_items`;
CREATE TABLE `eb_package_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pck_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '套餐ID',
  `rel_type` varchar(10) DEFAULT '' COMMENT '关联类型【goods:商品 service:服务】',
  `rel_id` int(10) unsigned DEFAULT '0' COMMENT '关联ID',
  `rel_name` varchar(120) DEFAULT '' COMMENT '关联实体的名称（冗余）',
  `valid_nums` mediumint(8) DEFAULT NULL COMMENT '有效次数（valid_type为1单项计次时有值）',
  `price` decimal(10,2) unsigned DEFAULT '0.00',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mixed` (`rel_type`,`rel_id`) USING BTREE,
  KEY `pck` (`pck_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='套餐包内容';

-- ----------------------------
--  Table structure for `eb_phone_user`
-- ----------------------------
DROP TABLE IF EXISTS `eb_phone_user`;
CREATE TABLE `eb_phone_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号码',
  `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '用户头像',
  `nickname` varchar(255) NOT NULL DEFAULT '' COMMENT '用户昵称',
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT 'user用户id,不关联为0',
  `grade_id` int(11) NOT NULL DEFAULT '0' COMMENT '年级id',
  `new_money` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '用户余额',
  `level` tinyint(1) NOT NULL DEFAULT '0' COMMENT '用户等级',
  `add_ip` varchar(16) NOT NULL DEFAULT '' COMMENT '添加ip',
  `pwd` varchar(32) NOT NULL DEFAULT '' COMMENT '登录密码',
  `spread_uid` int(11) NOT NULL DEFAULT '0' COMMENT '推广员id',
  `is_promoter` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为推广员',
  `add_time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `last_time` int(11) NOT NULL DEFAULT '0' COMMENT '登录时间',
  `last_ip` varchar(16) NOT NULL DEFAULT '' COMMENT '登录id',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否禁止,0=禁止,1=开启',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2501 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='手机号码注册用户表';

-- ----------------------------
--  Records of `eb_phone_user`
-- ----------------------------
BEGIN;
INSERT INTO `eb_phone_user` VALUES ('2482', '17602515294', '/public/system/images/user_log.jpg', '17602515294', '83961', '0', '0.00', '0', '58.212.197.66', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1612945074', '1612945133', '58.212.197.66', '1'), ('2483', '15588888888', '/public/system/images/user_log.jpg', '15588888888', '84134', '0', '0.00', '0', '117.89.130.5', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1623052608', '0', '', '1'), ('2484', '18151635095', '/public/system/images/user_log.jpg', '18151635095', '84142', '0', '0.00', '0', '36.28.171.108', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1623488550', '0', '', '1'), ('2486', '15317519598', '/public/system/images/user_log.jpg', '15317519598', '84146', '0', '0.00', '0', '180.158.30.34', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1623840519', '1623885826', '101.81.84.208', '1'), ('2487', '18250853712', '/public/system/images/user_log.jpg', '18250853712', '84148', '0', '0.00', '0', '112.65.48.175', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1623893703', '0', '', '1'), ('2488', '18309620919', '/public/system/images/user_log.jpg', '18309620919', '84149', '0', '0.00', '0', '223.104.147.43', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1623895609', '1623907849', '223.104.147.43', '1'), ('2489', '18014832927', '/public/system/images/user_log.jpg', '18014832927', '84150', '0', '0.00', '0', '49.90.180.39', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1623896426', '0', '', '1'), ('2491', '15952029944', '/public/system/images/user_log.jpg', '15952029944', '84301', '0', '0.00', '0', '117.89.12.253', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1623925624', '1624157070', '223.104.146.92', '1'), ('2492', '15316825987', '/public/system/images/user_log.jpg', '15316825987', '84153', '0', '0.00', '0', '101.81.84.208', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1623926083', '0', '', '1'), ('2493', '17721395006', '/public/system/images/user_log.jpg', '17721395006', '84154', '0', '0.00', '0', '117.143.172.239', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1623927302', '1624342352', '117.143.172.219', '1'), ('2494', '15151410133', '/public/system/images/user_log.jpg', '15151410133', '84184', '0', '0.00', '0', '117.89.12.253', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1624002157', '0', '', '1'), ('2495', '15910645043', '/public/system/images/user_log.jpg', '15910645043', '84171', '0', '0.00', '0', '117.136.45.146', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1624079550', '0', '', '1'), ('2496', '15601716937', '/public/system/images/user_log.jpg', '15601716937', '84175', '0', '0.00', '0', '180.158.30.34', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1624169389', '0', '', '1'), ('2497', '17778029707', '/public/system/images/user_log.jpg', '17778029707', '84177', '0', '0.00', '0', '1.89.51.178', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1624234489', '0', '', '1'), ('2498', '13901732490', '/public/system/images/user_log.jpg', '13901732490', '84179', '0', '0.00', '0', '101.86.189.206', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1624271670', '0', '', '1'), ('2499', '17887285621', '/public/system/images/user_log.jpg', '17887285621', '84160', '0', '0.00', '0', '43.255.75.81', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1625106642', '0', '', '1'), ('2500', '13611593654', '/public/system/images/user_log.jpg', '13611593654', '84328', '0', '0.00', '0', '117.89.12.253', 'e10adc3949ba59abbe56e057f20f883e', '0', '0', '1626657346', '0', '', '1');
COMMIT;

-- ----------------------------
--  Table structure for `eb_school`
-- ----------------------------
DROP TABLE IF EXISTS `eb_school`;
CREATE TABLE `eb_school` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `school_name` varchar(120) DEFAULT '' COMMENT '学校名称',
  `header_name` varchar(60) DEFAULT '' COMMENT '负责人姓名',
  `header_phone` varchar(20) DEFAULT '' COMMENT '负责人电话',
  `province` varchar(60) DEFAULT '' COMMENT '省',
  `city` varchar(60) DEFAULT '' COMMENT '市',
  `distinct` varchar(60) DEFAULT '' COMMENT '区',
  `address` varchar(255) DEFAULT '' COMMENT '地址',
  `is_del` int(10) unsigned DEFAULT '0' COMMENT '是否删除',
  `org_id` int(10) unsigned DEFAULT '0',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '上下架状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='校区';

-- ----------------------------
--  Records of `eb_school`
-- ----------------------------
BEGIN;
INSERT INTO `eb_school` VALUES ('6', '测试校区', '张三', '13888888888', '江苏省', '南京市', '江宁区', '龙眠大道388号', '0', '1', '0'), ('7', '奥南一校区', '荀洁', '19952413722', '江苏省', '南京市', '建邺区', '高庙路60号8栋0102室', '0', '1', '1'), ('8', '浦外校区', '杨思思', '19951980738', '江苏省', '南京市', '江北新区', '苏尚生活广场二楼2A04', '0', '1', '0'), ('9', '玄武校区', '宋亚宁', '19951923168', '江苏省', '南京市', '玄武区', '钟山花园博雅居4栋102室', '0', '1', '0'), ('10', '岱山校区', '荀洁', '19952413722', '江苏省', '南京市', '雨花台区', '岱山中路307号', '0', '1', '0'), ('11', '龙江校区', '胥荔', '13584542103', '江苏省', '南京市', '鼓楼区', '湘江路32号j52教育文化广场二楼', '0', '1', '0'), ('12', '鼓楼江苏商厦校区', '张瑞瑞', '17887285621', '江苏', '南京', '鼓楼区', '江苏商厦1710', '0', '2', '1'), ('13', '圆源文化工作室', '陆晓敏', '15317519598', '上海', '上海', '闵行', '闵行区银春路2200弄', '0', '3', '1'), ('14', '奥南二校区', '宋亚宁', '18931372514', '江苏省', '南京市', '建邺区', '奥和雅苑2幢商业7室', '0', '1', '1'), ('15', '奥南二校区', '荀洁', '19952413722', '江苏省', '南京市', '', '', '1626146094', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `eb_service`
-- ----------------------------
DROP TABLE IF EXISTS `eb_service`;
CREATE TABLE `eb_service` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) DEFAULT '' COMMENT '商品名称',
  `price` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '售价',
  `original_price` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '原价',
  `cover` varchar(255) DEFAULT '' COMMENT '封面图',
  `service_minutes` smallint(6) DEFAULT NULL COMMENT '服务分钟数',
  `label` varchar(512) DEFAULT '' COMMENT '标签',
  `is_rmt` tinyint(2) unsigned DEFAULT '0' COMMENT '推荐至前台',
  `cate_id` smallint(5) unsigned DEFAULT '0' COMMENT '分类ID',
  `status` tinyint(2) unsigned DEFAULT '1' COMMENT '状态',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '所属机构',
  `school_id` int(10) unsigned DEFAULT '0' COMMENT '所属分店',
  `is_del` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mix` (`org_id`,`school_id`,`is_del`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='服务项目表';

-- ----------------------------
--  Records of `eb_service`
-- ----------------------------
BEGIN;
INSERT INTO `eb_service` VALUES ('1', '推拿', '499.00', '0.00', '[]', '90', '[\"舒缓神经\",\"缓解疲劳\"]', '0', '0', '1', '1', '7', '0');
COMMIT;

-- ----------------------------
--  Table structure for `eb_sms_code`
-- ----------------------------
DROP TABLE IF EXISTS `eb_sms_code`;
CREATE TABLE `eb_sms_code` (
  `id` int(5) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `tel` varchar(20) NOT NULL COMMENT '电话号码',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `code` int(8) unsigned NOT NULL COMMENT '验证码',
  `last_time` int(11) unsigned NOT NULL COMMENT '过期时间',
  `is_use` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否已使用',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `id` (`id`) USING BTREE,
  KEY `id_2` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Table structure for `eb_system_admin`
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_admin`;
CREATE TABLE `eb_system_admin` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '后台管理员表ID',
  `account` varchar(32) NOT NULL COMMENT '后台管理员账号',
  `pwd` char(32) NOT NULL COMMENT '后台管理员密码',
  `real_name` varchar(16) NOT NULL COMMENT '后台管理员姓名',
  `roles` varchar(128) NOT NULL COMMENT '后台管理员权限(menus_id)',
  `school_id` int(10) unsigned DEFAULT '0' COMMENT '所在校区',
  `last_ip` varchar(16) DEFAULT NULL COMMENT '后台管理员最后一次登录ip',
  `last_time` int(10) unsigned DEFAULT NULL COMMENT '后台管理员最后一次登录时间',
  `add_time` int(10) unsigned NOT NULL COMMENT '后台管理员添加时间',
  `login_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',
  `level` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '后台管理员级别',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '后台管理员状态 1有效0无效',
  `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '所属机构',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `account` (`account`) USING BTREE,
  KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台管理员表';

-- ----------------------------
--  Records of `eb_system_admin`
-- ----------------------------
BEGIN;
INSERT INTO `eb_system_admin` VALUES ('1', 'admin', 'eda310e81c0856cc33c688a58ada3e76', 'admin', '1', '0', '127.0.0.1', '1630247250', '1539570661', '0', '0', '1', '0', '0'), ('10', 'dounixue', 'eda310e81c0856cc33c688a58ada3e76', '逗你学官方品牌运营商', '26', '0', '127.0.0.1', '1630248970', '1611557911', '0', '1', '1', '0', '1'), ('11', 'teacher', '8b79f88b2e5a34d6adef4a171c34ac27', '老师帐号', '27', '0', '117.89.71.61', '1617765343', '1613984882', '0', '1', '0', '1', '1'), ('12', 'hedabai', 'eda310e81c0856cc33c688a58ada3e76', '陈静彤', '26', '0', '117.89.14.173', '1615455846', '1615273740', '0', '1', '0', '1', '1'), ('13', 'aonan01', 'eda310e81c0856cc33c688a58ada3e76', '逗你学-奥南校区', '28', '7', '180.111.224.175', '1627031425', '1618557077', '0', '1', '1', '0', '1'), ('14', 'xuanwu01', 'eda310e81c0856cc33c688a58ada3e76', '逗你学-玄武校区', '28', '9', '58.212.135.217', '1625544237', '1618987152', '0', '1', '1', '0', '1'), ('15', 'puwai01', 'eda310e81c0856cc33c688a58ada3e76', '逗你学-浦外校区', '28', '8', '180.111.224.175', '1625801221', '1618987185', '0', '1', '1', '0', '1'), ('16', 'daishan01', 'eda310e81c0856cc33c688a58ada3e76', '逗你学-岱山校区', '28', '10', '117.89.131.52', '1620717142', '1619403625', '0', '1', '1', '0', '1'), ('17', 'longjiang01', 'eda310e81c0856cc33c688a58ada3e76', '逗你学-龙江校区', '28', '11', '223.65.184.121', '1622167182', '1619403758', '0', '1', '1', '0', '1'), ('18', 'test001', '8b79f88b2e5a34d6adef4a171c34ac27', '测试校区管理员', '28', '6', '117.89.12.253', '1623916246', '1619604160', '0', '1', '1', '0', '1'), ('19', 'ceshi01', 'eda310e81c0856cc33c688a58ada3e76', '测试人员', '27', '6', '117.89.12.253', '1623740333', '1619660193', '0', '1', '1', '0', '1'), ('20', 'youyouyuwen', '471192a8e043a3db0eddf32a55a97e65', '瑞瑞老师', '26', '0', '43.255.75.125', '1626958122', '1623403986', '0', '1', '1', '0', '2'), ('21', 'yuanyuangongzuoshi', '8020697150795fa2fb3351225887f670', '陆老师', '26', '0', '101.224.225.236', '1626399353', '1623821774', '0', '1', '1', '0', '3'), ('22', 'mianstudio', 'e9632707149504c982091b1e10205994', '米安-米老师', '26', '0', '117.89.12.253', '1624498268', '1624498257', '0', '1', '1', '0', '4'), ('23', 'aonan02', 'eda310e81c0856cc33c688a58ada3e76', '宋亚宁', '28', '14', '112.20.124.113', '1627031827', '1625638720', '0', '1', '1', '0', '1'), ('24', 'aonan01xu', 'eda310e81c0856cc33c688a58ada3e76', '许德俊', '28', '7', null, null, '1625639166', '0', '1', '1', '0', '1'), ('25', 'aonan02wang', 'eda310e81c0856cc33c688a58ada3e76', '王源凯', '28', '14', '180.111.224.175', '1625709407', '1625639227', '0', '1', '1', '0', '1'), ('26', 'aonan01wang', 'eda310e81c0856cc33c688a58ada3e76', '王源凯', '28', '7', '180.111.224.175', '1625709361', '1625639892', '0', '1', '1', '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `eb_system_config`
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_config`;
CREATE TABLE `eb_system_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置id',
  `menu_name` varchar(255) NOT NULL COMMENT '字段名称',
  `type` varchar(255) NOT NULL COMMENT '类型(文本框,单选按钮...)',
  `config_tab_id` int(10) unsigned NOT NULL COMMENT '配置分类id',
  `parameter` varchar(255) DEFAULT NULL COMMENT '规则 单选框和多选框',
  `upload_type` tinyint(1) unsigned DEFAULT NULL COMMENT '上传文件格式1单图2多图3文件',
  `required` varchar(255) DEFAULT NULL COMMENT '规则',
  `width` int(10) unsigned DEFAULT NULL COMMENT '多行文本框的宽度',
  `high` int(10) unsigned DEFAULT NULL COMMENT '多行文框的高度',
  `value` varchar(5000) DEFAULT NULL COMMENT '默认值',
  `info` varchar(255) NOT NULL COMMENT '配置名称',
  `desc` varchar(255) DEFAULT NULL COMMENT '配置简介',
  `sort` int(10) unsigned NOT NULL COMMENT '排序',
  `status` tinyint(1) unsigned NOT NULL COMMENT '是否隐藏',
  `org_id` int(10) unsigned DEFAULT '1' COMMENT '机构ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `un` (`menu_name`,`org_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=282 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='配置表';

-- ----------------------------
--  Records of `eb_system_config`
-- ----------------------------
BEGIN;
INSERT INTO `eb_system_config` VALUES ('1', 'site_name', 'text', '1', '', '0', 'required:true', '100', '0', '\"\\u5bb6\\u6821\\u4e92\\u52a8\"', '网站名称', '网站名称', '0', '1', '1'), ('2', 'site_url', 'text', '1', '', '0', 'required:true,url:true', '100', '0', '\"https:\\/\\/study-center.dounixue.net\\/\"', '网站地址', '网站地址', '0', '1', '1'), ('3', 'site_logo', 'upload', '1', '', '1', '', '0', '0', '\"\\/public\\/uploads\\/config\\/image\\/60d2c9e76b486.jpg\"', '后台LOGO', '左上角logo,建议尺寸[170*50]', '0', '1', '1'), ('4', 'site_phone', 'text', '1', '', '0', '', '100', '0', '\"13772193154\"', '联系电话', '联系电话', '0', '1', '1'), ('5', 'seo_title', 'text', '1', '', '0', 'required:true', '100', '0', '\"\\u5bb6\\u6821\\u4e92\\u52a8\\uff0c\\u8f7b\\u677e\\u5b66\\uff01\"', 'SEO标题', 'SEO标题', '0', '1', '1'), ('6', 'site_email', 'text', '1', '', '0', 'email:true', '100', '0', '\"study-center@dounixue.net\"', '联系邮箱', '联系邮箱', '0', '1', '1'), ('7', 'site_qq', 'text', '1', '', '0', 'qq:true', '100', '0', '\"98718401\"', '联系QQ', '联系QQ', '0', '1', '1'), ('8', 'site_close', 'radio', '1', '0=开启\n1=PC端关闭\n2=WAP端关闭(含微信)\n3=全部关闭', '0', '', '0', '0', '\"0\"', '网站关闭', '网站后台、商家中心不受影响。关闭网站也可访问', '0', '1', '1'), ('9', 'close_system', 'radio', '1', '0=开启\n1=关闭', '0', '', '0', '0', '\"0\"', '关闭后台', '关闭后台', '0', '2', '1'), ('10', 'wechat_name', 'text', '2', '', '0', 'required:true', '100', '0', '\"\\u9017\\u4f60\\u5b66\\u81ea\\u9002\\u5e94\\u5b66\\u4e60\\u4e2d\\u5fc3\"', '公众号名称', '公众号的名称', '0', '1', '1'), ('11', 'wechat_id', 'text', '2', '', '0', 'required:true', '100', '0', '\"\\u9017\\u4f60\\u5b66\"', '微信号', '微信号', '0', '1', '1'), ('12', 'wechat_sourceid', 'text', '2', '', '0', 'required:true', '100', '0', '\"gh_5857239fd021\"', '公众号原始id', '公众号原始id', '0', '1', '1'), ('13', 'wechat_appid', 'text', '2', '', '0', 'required:true', '100', '0', '\"wxaa0f2f28e0f55c80\"', 'AppID', 'AppID', '0', '1', '1'), ('14', 'wechat_appsecret', 'text', '2', '', '0', 'required:true', '100', '0', '\"e1306a75e5732f16588179a157ed2c8c\"', 'AppSecret', 'AppSecret', '0', '1', '1'), ('15', 'wechat_token', 'text', '2', '', '0', 'required:true', '100', '0', '\"4f17e5e8dc5705da4faa2adef70862fd\"', '微信验证TOKEN', '微信验证TOKEN', '0', '1', '1'), ('16', 'wechat_encode', 'radio', '2', '0=明文模式\n1=兼容模式\n2=安全模式', '0', '', '0', '0', '\"0\"', '消息加解密方式', '如需使用安全模式请在管理中心修改，仅限服务号和认证订阅号', '0', '1', '1'), ('17', 'wechat_encodingaeskey', 'text', '2', '', '0', 'required:true', '100', '0', '\"nT4mAfLsi0MrrPfBcmbwqCRXBYOdJGzcIWHQiAyPrrC\"', 'EncodingAESKey', '公众号消息加解密Key,在使用安全模式情况下要填写该值，请先在管理中心修改，然后填写该值，仅限服务号和认证订阅号', '0', '1', '1'), ('18', 'wechat_share_img', 'upload', '2', '', '1', '', '0', '0', '\"\\/public\\/uploads\\/config\\/image\\/5c9aef0f37964.jpg\"', '微信分享图片', '若填写此图片地址，则分享网页出去时会分享此图片。可有效防止分享图片变形', '0', '0', '1'), ('19', 'wechat_qrcode', 'upload', '2', '', '1', '', '0', '0', '\"\\/public\\/uploads\\/config\\/image\\/5dd36d0c14456.jpg\"', '公众号二维码', '您的公众号二维码', '0', '1', '1'), ('20', 'wechat_type', 'radio', '2', '0=服务号\n1=订阅号', '0', '', '0', '0', '\"0\"', '公众号类型', '公众号的类型', '0', '1', '1'), ('21', 'wechat_share_title', 'text', '2', '', '0', 'required:true', '100', '0', '\"\\u9017\\u4f60\\u5b66-\\u7cbe\\u54c1\\u665a\\u8f85\"', '微信分享标题', '微信分享标题', '0', '1', '1'), ('22', 'wechat_share_synopsis', 'textarea', '2', '', '0', '', '100', '5', '\"\\u5c0f\\/\\u521d\\/\\u9ad8\\u7cbe\\u54c1\\u665a\\u8f85\\uff0c\\u66f4\\u6709\\u52a8\\u753b\\u5fae\\u8bfe\\uff0c3\\u5206\\u949f\\u5403\\u900f\\u77e5\\u8bc6\\u70b9\\uff0c\\u8f7b\\u677e\\u5b66\\uff01\"', '微信分享简介', '微信分享简介', '0', '1', '1'), ('23', 'pay_weixin_appid', 'text', '4', '', '0', '', '100', '0', '\"wxaa0f2f28e0f55c80\"', 'Appid', '微信公众号身份的唯一标识。审核通过后，在微信发送的邮件中查看。', '0', '1', '1'), ('24', 'pay_weixin_appsecret', 'text', '4', '', '0', '', '100', '0', '\"e1306a75e5732f16588179a157ed2c8c\"', 'Appsecret', 'JSAPI接口中获取openid，审核后在公众平台开启开发模式后可查看。', '0', '1', '1'), ('25', 'pay_weixin_mchid', 'text', '4', '', '0', '', '100', '0', '\"1491015872\"', 'Mchid', '受理商ID，身份标识', '0', '1', '1'), ('26', 'pay_weixin_client_cert', 'upload', '4', '', '3', '', '0', '0', '\"\\/public\\/uploads\\/config\\/file\\/60e5ce9f43a1e.pem\"', '微信支付证书', '微信支付证书，在微信商家平台中可以下载！文件名一般为apiclient_cert.pem', '0', '1', '1'), ('27', 'pay_weixin_client_key', 'upload', '4', '', '3', '', '0', '0', '\"\\/public\\/uploads\\/config\\/file\\/60e5ceb0dea86.pem\"', '微信支付证书密钥', '微信支付证书密钥，在微信商家平台中可以下载！文件名一般为apiclient_key.pem', '0', '1', '1'), ('28', 'pay_weixin_key', 'text', '4', '', '0', '', '100', '0', '\"BC4E5748B58B56529F5AF44295A64DB4\"', 'Key', '商户支付密钥Key。审核通过后，在微信发送的邮件中查看。', '0', '1', '1'), ('29', 'pay_weixin_open', 'radio', '4', '1=开启\n0=关闭', '0', '', '0', '0', '\"1\"', '开启', '是否启用微信支付', '0', '1', '1'), ('31', 'store_postage', 'text', '10', '', '0', 'number:true,min:0', '100', '0', '\"12\"', '邮费基础价', '商品邮费基础价格,最终金额为(基础价 + 商品1邮费 + 商品2邮费)', '0', '1', '1'), ('32', 'store_free_postage', 'text', '5', '', '0', 'number:true,min:-1', '100', '0', '\"200\"', '满额包邮', '商城商品满多少金额即可包邮', '0', '1', '1'), ('33', 'offline_postage', 'radio', '10', '0=不包邮\n1=包邮', '0', '', '0', '0', '\"1\"', '线下支付是否包邮', '用户选择线下支付时是否包邮', '0', '1', '1'), ('34', 'integral_ratio', 'text', '11', '', '0', 'number:true', '100', '0', '\"0.01\"', '积分抵用比例', '积分抵用比例(1积分抵多少金额)', '0', '1', '1'), ('35', 'site_service_phone', 'text', '1', '', '0', '', '100', '0', '\"400-8888794\"', '客服电话', '客服联系电话', '0', '1', '1'), ('44', 'store_user_min_recharge', 'text', '5', '', '0', 'required:true,number:true,min:0', '100', '0', '\"0.01\"', '用户最低充值金额', '用户单次最低充值金额', '0', '0', '1'), ('45', 'site_store_admin_uids', 'text', '5', '', '0', '', '100', '0', '\"8\"', '管理员用户ID', '管理员用户ID,用于接收商城订单提醒，到微信用户中查找编号，多个英文‘,’隔开', '0', '1', '1'), ('46', 'system_express_app_code', 'text', '10', '', '0', '', '100', '0', '\"dbc3c1426efe44fdb6c0aa04c52a4ca9\"', '快递查询密钥', '阿里云快递查询接口密钥购买地址：https://market.aliyun.com/products/57126001/cmapi011120.html', '0', '1', '1'), ('47', 'main_business', 'text', '2', '', '0', 'required:true', '100', '0', '\" IT\\u79d1\\u6280 \\u4e92\\u8054\\u7f51|\\u7535\\u5b50\\u5546\\u52a1\"', '微信模板消息_主营行业', '微信公众号模板消息中选择开通的主营行业', '0', '0', '1'), ('48', 'vice_business', 'text', '2', '', '0', 'required:true', '100', '0', '\"IT\\u79d1\\u6280 IT\\u8f6f\\u4ef6\\u4e0e\\u670d\\u52a1 \"', '微信模板消息_副营行业', '微信公众号模板消息中选择开通的副营行业', '0', '0', '1'), ('49', 'store_brokerage_ratio', 'text', '9', null, null, 'required:true,min:0,max:100,number:true', '100', '0', '\"50\"', '链接返佣比例', '订单交易成功后给上级返佣的比例0 - 100,例:5 = 反订单金额的5%', '5', '1', '1'), ('50', 'wechat_first_sub_give_coupon', 'text', '12', '', '0', 'requred:true,digits:true,min:0', '100', '0', '\"\"', '首次关注赠送优惠券ID', '首次关注赠送优惠券ID,0为不赠送', '0', '1', '1'), ('51', 'store_give_con_min_price', 'text', '12', '', '0', 'requred:true,digits:true,min:0', '100', '0', '\"0.01\"', '消费满多少赠送优惠券', '消费满多少赠送优惠券,0为不赠送', '0', '1', '1'), ('52', 'store_order_give_coupon', 'text', '12', '', '0', 'requred:true,digits:true,min:0', '100', '0', '\"\"', '消费赠送优惠劵ID', '消费赠送优惠劵ID,0为不赠送', '0', '1', '1'), ('54', 'sx_sign_min_int', 'text', '11', '', '0', 'required:true,number:true,min:0', '100', '0', '\"1\"', '签到奖励最低积分', '签到奖励最低积分', '0', '1', '1'), ('55', 'sx_sign_max_int', 'text', '11', '', '0', 'required:true,number:true,min:0', '100', '0', '\"5\"', '签到奖励最高积分', '签到奖励最高积分', '0', '1', '1'), ('57', 'about_us', 'upload', '1', '', '1', '', '0', '0', '\"\"', '关于我们', '系统的标识', '0', '1', '1'), ('58', 'replenishment_num', 'text', '5', '', '0', 'required:true,number:true,min:0', '100', '0', '\"20\"', '待补货数量', '产品待补货数量低于多少时，提示补货', '0', '1', '1'), ('59', 'routine_appId', 'text', '7', '', '0', '', '100', '0', '\"wx51a763effa400e50\"', 'appId', '小程序appID', '0', '1', '1'), ('60', 'routine_appsecret', 'text', '7', '', '0', '', '100', '0', '\"5eb8458dcfffe71e43cb8c6f6de421b1\"', 'AppSecret', '小程序AppSecret', '0', '1', '1'), ('61', 'api', 'text', '2', '', '0', '', '100', '0', '\"\\/wechat\\/index\\/serve\"', '接口地址', '微信接口例如：http://www.abc.com/wechat/index/serve', '0', '0', '1'), ('62', 'paydir', 'textarea', '4', '', '0', '', '100', '5', '\"\\/wap\\/my\\/\\r\\n\\/wap\\/my\\/order\\/uni\\/\\r\\n\\/wap\\/store\\/confirm_order\\/cartId\\/\"', '配置目录', '支付目录配置系统不调用提示作用', '0', '1', '1'), ('73', 'routine_logo', 'upload', '7', '', '1', '', '0', '0', '\"\"', '小程序logo', '小程序logo', '0', '1', '1'), ('74', 'routine_name', 'text', '7', '', '0', '', '100', '0', '\"\\u8f66\\u8054\\u76df\\u65b0\\u80fd\\u6e90\"', '小程序名称', '小程序名称', '0', '1', '1'), ('76', 'routine_style', 'text', '7', '', '0', '', '100', '0', '\"#FFFFFF\"', '小程序风格', '小程序颜色', '0', '1', '1'), ('77', 'store_stock', 'text', '5', '', '0', '', '100', '0', '\"1\"', '警戒库存', '警戒库存提醒值', '0', '1', '1'), ('85', 'stor_reason', 'textarea', '5', '', '0', '', '100', '8', '\"\\u6536\\u8d27\\u5730\\u5740\\u586b\\u9519\\u4e86=\\u4e0e\\u63cf\\u8ff0\\u4e0d\\u7b26=\\u4fe1\\u606f\\u586b\\u9519\\u4e86\\uff0c\\u91cd\\u65b0\\u62cd=\\u6536\\u5230\\u5546\\u54c1\\u635f\\u574f\\u4e86=\\u672a\\u6309\\u9884\\u5b9a\\u65f6\\u95f4\\u53d1\\u8d27=\\u5176\\u5b83\\u539f\\u56e0\"', '退货理由', '配置退货理由，一行一个理由', '0', '1', '1'), ('87', 'store_brokerage_two', 'text', '9', null, null, 'required:true,min:0,max:100,number:true', '100', '0', '\"30\"', '一级返佣比例', '订单交易成功后给上级返佣的比例0 - 100,例:5 = 反订单金额的5%', '4', '1', '1'), ('88', 'store_brokerage_statu', 'radio', '9', '1=指定分销\n2=人人分销', '0', '', '0', '0', '\"1\"', '分销模式', '人人分销默认每个人都可以分销，制定人分销后台制定人开启分销', '10', '1', '1'), ('89', 'pay_routine_appid', 'text', '14', '', '0', 'required:true', '100', '0', '\"wx51a763effa400e50\"', 'Appid', '小程序Appid', '0', '1', '1'), ('90', 'pay_routine_appsecret', 'text', '14', '', '0', 'required:true', '100', '0', '\"5eb8458dcfffe71e43cb8c6f6de421b1\"', 'Appsecret', '小程序Appsecret', '0', '1', '1'), ('91', 'pay_routine_mchid', 'text', '14', '', '0', 'required:true', '100', '0', '\"1520804401\"', 'Mchid', '商户号', '0', '1', '1'), ('92', 'pay_routine_key', 'text', '14', '', '0', 'required:true', '100', '0', '\"2df7004f8ebcrmeb1f25234ac2bdaf12\"', 'Key', '商户key', '0', '1', '1'), ('93', 'pay_routine_client_cert', 'upload', '14', '', '3', '', '0', '0', '[\"\\/public\\/uploads\\/config\\/file\\/5c12fb7b9ebc5.pem\"]', '小程序支付证书', '小程序支付证书', '0', '1', '1'), ('94', 'pay_routine_client_key', 'upload', '14', '', '3', '', '0', '0', '[\"\\/public\\/uploads\\/config\\/file\\/5c12fb7eb8897.pem\"]', '小程序支付证书密钥', '小程序支付证书密钥', '0', '1', '1'), ('95', 'log_cycle', 'text', '1', '', '0', '', '100', '0', '\"30\"', '系统日志', '系统日志保存时间单位天', '0', '1', '1'), ('96', 'sign_in_integral', 'radio', '11', '1=开启\n0=关闭', null, null, null, null, '\"0\"', '签到送积分', '签到送积分显示开关', '0', '1', '1'), ('97', 'give_integral', 'radio', '11', '1=开启\n0=关闭', null, null, null, null, '\"0\"', '邀请好友赠送积分', '邀请好友赠送积分显示开关', '0', '1', '1'), ('98', 'share_integral', 'radio', '11', '1=开启\n0=关闭', null, null, null, null, '\"0\"', '分享商品送积分', '分享商品送积分开关', '0', '1', '1'), ('114', 'user_extract_bank', 'textarea', '5', null, null, null, '100', '6', '\"\\u62db\\u5546\\u94f6\\u884c=\\u5efa\\u8bbe\\u94f6\\u884c=\\u519c\\u4e1a\\u94f6\\u884c\"', '提现银行', '提现银行', '0', '1', '1'), ('116', 'index_recommend_url', 'upload', '15', null, '1', null, null, null, '[\"\\/public\\/uploads\\/config\\/image\\/5c1ef9f2594ea.png\"]', '主页推荐图', '主页推荐图', '0', '1', '1'), ('117', 'hot_food', 'upload', '15', null, '1', null, null, null, '\"\"', '热销菜品', '热销菜品', '0', '1', '1'), ('118', 'welcome_url', 'upload', '15', null, '1', null, null, null, '[\"\\/public\\/uploads\\/config\\/image\\/5c29e37db77e8.jpg\"]', '最受欢迎', '热销菜品', '0', '1', '1'), ('119', 'praise_part', 'text', '7', null, null, '', '100', null, '\"5\"', '用户给商户好评加分', '用户给商户好评加分', '0', '1', '1'), ('120', 'praise_bad_part', 'text', '7', null, null, '', '100', null, '\"8\"', '用户给商户差评减分分', '用户给商户好评加分', '0', '1', '1'), ('130', 'extract_min_money', 'text', '5', null, null, '', '100', null, '\"1\"', '提现最低金额', '提现最低金额', '0', '1', '1'), ('132', 'smsSignName', 'text', '1', null, null, '', '100', null, '\"\\u79ef\\u6b21\\u79d1\\u6280\"', '阿里云短信签名', '阿里云短信签名', '0', '1', '1'), ('133', 'accessKeyId', 'text', '1', null, null, '', '100', null, '\"LTAIlAOFBRlD1erS\"', '阿里云短信AccessKeyId', '阿里云短信AccessKeyId', '0', '1', '1'), ('134', 'accessKeySecret', 'text', '1', null, null, '', '100', null, '\"lwRCU7a4ZIS4KaMBMOZ805Z61UMl1r\"', '阿里云短信AccessKeySecret', '阿里云短信AccessKeySecret', '0', '1', '1'), ('135', 'smsTemplateCode', 'text', '1', null, null, '', '100', null, '\"SMS_157230173\"', '阿里云短信模板ID', '阿里云短信模板ID', '0', '1', '1'), ('138', 'access_key_id', 'text', '1', null, null, '', '100', null, '\"+vB0RuO22DeeanAAb0ig\"', '金山云ACCESS KEY ID', '金山云ACCESS KEY ID', '0', '1', '1'), ('139', 'access_sk', 'text', '1', null, null, '', '100', null, '\"3kbTp8pg+LymO84\\/ZyxG\\/od\\/3FeVDjWt+8\\/m5iBc\"', '金山云SK', '金山云SK', '0', '1', '1'), ('140', 'spread_poster_url', 'upload', '1', null, '1', null, null, null, '\"\"', '推广人海报', '推广人海报', '0', '0', '1'), ('141', 'special_gift_banner', 'upload', '2', null, '1', null, null, null, '\"\"', '专题发放banner图', '专题发放banner图', '0', '0', '1'), ('142', 'store_brokerage_three', 'text', '4', null, null, null, '100', null, '\"10\"', '普通推广人裂变返佣比例', '普通推广人裂变返佣比例', '0', '0', '1'), ('143', 'alipay_app_id', 'text', '4', null, null, '', '100', null, '\"2019021863275112\"', '蚂蚁金服appid', '蚂蚁金服appid', '0', '1', '1'), ('144', 'alipay_private_key', 'text', '4', null, null, '', '100', null, '\"MIIEpAIBAAKCAQEAqcZ7JfrS+l33Z4Zv3ElN1\\/H2pmdYFchc8ibiCEyh1N2JwEgc6sruMp5oH4zcAsvTxRpUXTg44c7PTz+yXN8wek104DQde+vb7xM0bQh92FGKblxdf66QhhPLSnN\\/Lt\\/UHoCuFJtIxalcnZyvHkdKuBenJpN\\/8cIkTLUpVkbzdsxLNyOy3c5cr8sPpjCg4a71Eu\\/fW3RjtUxi5ENxv7evqpkK144GUuwnBbgCkVjfXF2H4lvXoMw7\\/9NhC6AJ615otHp5PbznlWBdpTSLva0UCfbpP0PuwnlXOp6h9eV05OyFsVFd+GcqlNgBCn\\/PtvzG2evIjZqGXwtAAwXY52oXzwIDAQABAoIBAF5ThIBph2bLZnYCX4wIvlNIgD2cFXikxd9UcykhSpi2LZ7Dci2Rah59nGRLIsH69UIBivXwEsqC2POy9CpdZtXMyy72RZtgQ+Xkya\\/6k9DoHP2MG\\/agynNz8\\/L9kKA+g+AeppmUXS5VFrwLHdC4027M1XW9ZcywjPKBhOIGsaZCmy2oVWMzH9TufhgTzsttaBwmECxTl5GnXO8gP5j\\/5ylItB7PO0s9ty2MSJOxRLnFGtuh6\\/0VRp6xpHkl9ioMwTT2c4x9SbWjw9spoJ\\/cm4ODro4ZqNCFiFTiOkmsJ2iIk0SaVVGkJPp3d+kWGYTk+tvs62tf84uokAV077gNTWECgYEA3q5pQkdafSt25nOGyDaRBUk+gXfsHjWlp0pFHSKZvC3Gi0JnnM+cGrPSgOuUcNEzrpARGw4GrdIX3dWeI4KH33y8FWOMs26NrwaPQNACJ0\\/L9NrZuUH0GlPAxZcMCGHDORJmEeGrad36z8kRj8+dCHL0fc1lBSBSeCq1JNWUvnMCgYEAwy2O6aik9C\\/GoHKhBheAAOAekIVSwUHmzleA20GGdBysC373Q47kYLiTbgSj1bQ82vm6eGlA\\/NAqr+DOlMUA3aE0sr5egZSo0z4su4yGCEIlbZaOU3cjnk0v0N57CW59x+4Z4gKzKC\\/mil9IYNep\\/TjDGd8l9e2r9YB7TQWCLjUCgYEAsTZFqCxWtAQyBGXt3kmmkXlfl\\/MS4lu5L+\\/oHq6Zf+tB9TNsd5u01H9Ex7ozELE8GvCl3E0GPbBTtAO7bPEFJnMCz1bA807IzIBA4shm3lgfrQW5fTgihg0e\\/WAegFEk5rdgqVxZaM\\/yOQf\\/xN3pT38EWVVqznCRkPYT4HNkg0cCgYEApZQKv7MwbW\\/yg797V52sHBIGG\\/jfIdB0q+yUBm3qUKraUc5emlOo71zmxdjt3KhRUDu3s9snJNK8xARlfNQ8Tckq2dCigC\\/LoZoHfPxT4MGs2vF0wN47u1okDIARxQiVcH1QO+qqbpdkb1MyJeYP8iCrc1FZ9O6yiU18TPU1YVkCgYAFIyypjC1OQgXid9V5KqaB+9NwMLuXM0myJbawk1aVM8J10SGkoHlo9FmBkXutNpzV8K5JoIHu\\/ClLu6eoZYElwJvblbPGAlWb8IZ1sYThRVAOy9V2VXBCLHQKshD22VRv1m35ecb+bjAmuEdsdZzUFCqnN3SYwAp\\/42PyQhIddA==\"', '蚂蚁金服key', '蚂蚁金服key', '0', '1', '1'), ('145', 'alipay_public_key', 'text', '4', null, null, '', '100', null, '\"MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAlOTlvHG5FYvcaoNlQAS4xqmQeuw4JVdr4tNrf4AhXhlPTiE\\/mH4H4G5Kg8l9j41eNuOwJ3XDROhX2DvAc3AF1KtZQTHcJocd2bs7jOsEWr6k1tsvDvQAU+tfJV6LNy2NytX9AW+UsP9EUI\\/Jme\\/97IknYHoxer2a1XMEW+yU4RwtT+ZVHnnXsouRLjBtUcAVmf4S943aU\\/ExIWKtz\\/kJRnjgihTvW2LsMV4KtNUJtH0EvuphvlwhyYf6rFb7xnVDz1Ukh8cQ2lRZdBQiuhGcGzpa9QYKsumAgQ21LK1XZGiFY+UwamyhjQ1wSn9apgs2Wxk0HaIhxCuj57DkXIEO+QIDAQAB\"', '蚂蚁金服公钥', '蚂蚁金服公钥', '0', '1', '1'), ('146', 'promoter_content', 'textarea', '2', null, null, null, '100', '8', '\"1\\ufe0f\\u20e3\\u3000\\u8f93\\u5165\\u624b\\u673a\\u53f7\\u7801\\u53ca\\u9a8c\\u8bc1\\u7801\\uff0c\\u4e00\\u79d2\\u949f\\u5373\\u53ef\\u6210\\u4e3a\\u5168\\u7f51\\u552f\\u4e00\\u3001\\u5b8c\\u8bfe\\u7387\\u7b2c\\u4e0092.8%\\u3001\\u6df1\\u53d7\\u4e2d\\u5c0f\\u5b66\\u751f\\u559c\\u7231\\u7684\\u77e5\\u8bc6\\u70b9\\u77ed\\u89c6\\u9891-\\u201c\\u9017\\u4f60\\u5b66\\u201d-\\u7684\\u8363\\u8a89\\u63a8\\u5e7f\\u4eba\\u3002\\r\\n  \\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\r\\n2\\ufe0f\\u20e3\\u3000\\u201c\\u9017\\u4f60\\u5b66\\u201d\\u2014\\u2014\\u4e09\\u5206\\u949f\\u5b66\\u900f\\u4e00\\u4e2a\\u77e5\\u8bc6\\u70b9\\uff0c\\u5b66\\u5f97\\u8fdb\\u3001\\u5b66\\u5f97\\u4f1a\\u3001\\u901f\\u63d0\\u5206\\u3001\\u4e0d\\u4f24\\u773c\\u3002\\r\\n  \\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\r\\n3\\ufe0f\\u20e3\\u3000\\u5c0f\\u521d\\u9ad8\\u5168\\u5b66\\u79d1\\u8986\\u76d6\\uff0c\\u6ee1\\u8db3\\u9884\\u590d\\u4e60\\u3001\\u8865\\u5dee\\u62d4\\u5c16\\u7b49\\u5404\\u5c42\\u6b21\\u9700\\u6c42\\uff0c\\u4ef7\\u683c\\u5b9e\\u60e0\\u3001\\u9ad8\\u9891\\u6d88\\u8d39\\u3002\\u5206\\u4eab\\u4ea7\\u751f\\u8d2d\\u4e70\\uff0c\\u5373\\u53ef\\u83b7\\u5f97\\u4e0d\\u4f4e\\u4e8e\\u8ba2\\u5355\\u4ef730%\\u56de\\u62a5\\u3002\\r\\n  \\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\r\\n4\\ufe0f\\u20e3\\u3000\\u63a8\\u5e7f\\u8bfe\\u7a0b\\u4fbf\\u6377\\u6613\\u4e0a\\u624b\\uff0c\\u52a8\\u52a8\\u624b\\u6307\\u5373\\u53ef\\u5206\\u4eab\\u3002\\u5ba2\\u670d\\u5fae\\u4fe1\\uff1adounixue007\"', '推广细则', '推广细则', '0', '0', '1'), ('147', 'promoter_guide', 'textarea', '2', null, null, null, '100', '8', '\"\\u63a8\\u5e7f\\u8fc7\\u7a0b\\u4e2d\\uff0c\\u5982\\u6709\\u7591\\u95ee\\u8bf7\\u54a8\\u8be2\\u9017\\u4f60\\u5b66\\u5ba2\\u670d-\\u5434\\u8001\\u5e08\\uff0c\\u5fae\\u4fe1\\u53f7\\uff1adounixue007\\r\\n  \\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\"', '推荐指引', '推荐指引', '0', '0', '1'), ('148', 'store_brokerage_three_senior', 'text', '9', null, null, null, '100', null, '\"20\"', '高级推广人裂变返佣比例', '高级推广人裂变返佣比例', '0', '1', '1'), ('149', 'binding_time', 'text', '1', null, null, '', '100', null, '\"\"', '客户关系绑定时间', '客户关系绑定时间', '0', '1', '1'), ('150', 'open_barrage', 'radio', '1', '1=开启\n0=关闭', '0', null, '100', null, '\"1\"', '虚拟用户专题弹幕开关', '虚拟用户专题弹幕开关', '0', '0', '1'), ('151', 'store_brokerage_three_3x_num', 'text', '9', null, null, '', '100', null, '\"1000\"', '三星推广人可发展下线人数', '三星推广人可发展下线人数', '0', '1', '1'), ('152', 'store_brokerage_three_2x_num', 'text', '9', null, null, '', '100', null, '\"500\"', '二星推广人可发展下线人数', '二星推广人可发展下线人数', '0', '1', '1'), ('153', 'store_brokerage_three_1x_num', 'text', '9', null, null, '', '100', null, '\"20\"', '一星推广人可发展下线人数', '一星推广人可发展下线人数', '0', '1', '1'), ('154', 'store_brokerage_three_3x', 'text', '9', null, null, '', '100', null, '\"0\"', '普通推广人裂变返佣比例三星', '普通推广人裂变返佣比例三星', '0', '1', '1'), ('155', 'store_brokerage_three_2x', 'text', '9', null, null, '', '100', null, '\"20\"', '普通推广人裂变返佣比例二星', '普通推广人裂变返佣比例二星', '0', '1', '1'), ('156', 'store_brokerage_three_1x', 'text', '9', null, null, '', '100', null, '\"10\"', '普通推广人裂变返佣比例一星', '普通推广人裂变返佣比例一星', '0', '1', '1'), ('157', 'store_brokerage_three_0x', 'text', '9', null, null, '', '100', null, '\"0\"', '普通推广人裂变返佣比例零星', '普通推广人裂变返佣比例零星', '0', '1', '1'), ('158', 'barrage_show_time', 'text', '9', null, null, null, null, null, '500', '', null, '0', '0', '1'), ('210', 'site_phone', 'text', '1', '', '0', '', '100', '0', '', '联系电话', '联系电话', '0', '1', '2'), ('211', 'site_email', 'text', '1', '', '0', 'email:true', '100', '0', '', '联系邮箱', '联系邮箱', '0', '1', '2'), ('212', 'site_qq', 'text', '1', '', '0', 'qq:true', '100', '0', '', '联系QQ', '联系QQ', '0', '1', '2'), ('213', 'wechat_name', 'text', '2', '', '0', 'required:true', '100', '0', '\"\\u60a0\\u60a0\\u8bed\\u6587\"', '公众号名称', '公众号的名称', '0', '1', '2'), ('214', 'wechat_id', 'text', '2', '', '0', 'required:true', '100', '0', '\"\\u60a0\\u60a0\\u8bed\\u6587\"', '微信号', '微信号', '0', '1', '2'), ('215', 'wechat_sourceid', 'text', '2', '', '0', 'required:true', '100', '0', '\"wxc7a3e93c47804eff\"', '公众号原始id', '公众号原始id', '0', '1', '2'), ('216', 'wechat_appid', 'text', '2', '', '0', 'required:true', '100', '0', '\"wxc7a3e93c47804eff\"', 'AppID', 'AppID', '0', '1', '2'), ('217', 'wechat_appsecret', 'text', '2', '', '0', 'required:true', '100', '0', '\"0f3eeadb61c4c65bf6dcdae8e263601e\"', 'AppSecret', 'AppSecret', '0', '1', '2'), ('218', 'wechat_token', 'text', '2', '', '0', 'required:true', '100', '0', '\"4f17e5e8dc5705da4faa2adef70862fd\"', '微信验证TOKEN', '微信验证TOKEN', '0', '1', '2'), ('219', 'wechat_encode', 'radio', '2', '0=明文模式\n1=兼容模式\n2=安全模式', '0', '', '0', '0', '\"0\"', '消息加解密方式', '如需使用安全模式请在管理中心修改，仅限服务号和认证订阅号', '0', '1', '2'), ('220', 'wechat_encodingaeskey', 'text', '2', '', '0', 'required:true', '100', '0', '\"nT4mAfLsi0MrrPfBcmbwqCRXBYOdJGzcIWHQiAyPrrC\"', 'EncodingAESKey', '公众号消息加解密Key,在使用安全模式情况下要填写该值，请先在管理中心修改，然后填写该值，仅限服务号和认证订阅号', '0', '1', '2'), ('221', 'wechat_share_img', 'upload', '2', '', '1', '', '0', '0', '\"\"', '微信分享图片', '若填写此图片地址，则分享网页出去时会分享此图片。可有效防止分享图片变形', '0', '1', '2'), ('222', 'wechat_qrcode', 'upload', '2', '', '1', '', '0', '0', '\"\\/public\\/uploads\\/config\\/image\\/60da763a98a22.jpg\"', '公众号二维码', '您的公众号二维码', '0', '1', '2'), ('223', 'wechat_type', 'radio', '2', '0=服务号\n1=订阅号', '0', '', '0', '0', '\"0\"', '公众号类型', '公众号的类型', '0', '1', '2'), ('224', 'wechat_share_title', 'text', '2', '', '0', 'required:true', '100', '0', '\"\\u60a0\\u60a0\\u8bed\\u6587\"', '微信分享标题', '微信分享标题', '0', '1', '2'), ('225', 'wechat_share_synopsis', 'textarea', '2', '', '0', '', '100', '5', '\"\\u4e3a\\u8bed\\u6587\\u800c\\u6765\\uff0c\\u6df1\\u8015\\u6559\\u5b66\\uff0c\\u4e13\\u7814\\u4e2d\\u3001\\u5c0f\\u5b66\\u9605\\u8bfb\\u65b9\\u6cd5\\uff0c\\u5199\\u4f5c\\u6280\\u5de7\\u3002\"', '微信分享简介', '微信分享简介', '0', '1', '2'), ('226', 'pay_weixin_appid', 'text', '4', '', '0', '', '100', '0', '', 'Appid', '微信公众号身份的唯一标识。审核通过后，在微信发送的邮件中查看。', '0', '1', '2'), ('227', 'pay_weixin_appsecret', 'text', '4', '', '0', '', '100', '0', '', 'Appsecret', 'JSAPI接口中获取openid，审核后在公众平台开启开发模式后可查看。', '0', '1', '2'), ('228', 'pay_weixin_mchid', 'text', '4', '', '0', '', '100', '0', '', 'Mchid', '受理商ID，身份标识', '0', '1', '2'), ('229', 'pay_weixin_client_cert', 'upload', '4', '', '3', '', '0', '0', '', '微信支付证书', '微信支付证书，在微信商家平台中可以下载！文件名一般为apiclient_cert.pem', '0', '1', '2'), ('230', 'pay_weixin_client_key', 'upload', '4', '', '3', '', '0', '0', '', '微信支付证书密钥', '微信支付证书密钥，在微信商家平台中可以下载！文件名一般为apiclient_key.pem', '0', '1', '2'), ('231', 'pay_weixin_key', 'text', '4', '', '0', '', '100', '0', '', 'Key', '商户支付密钥Key。审核通过后，在微信发送的邮件中查看。', '0', '1', '2'), ('232', 'site_service_phone', 'text', '1', '', '0', '', '100', '0', '', '客服电话', '客服联系电话', '0', '1', '2'), ('233', 'api', 'text', '2', '', '0', '', '100', '0', '\"\\/wechat\\/index\\/serve\"', '接口地址', '保持默认，谨慎修改。微信接口例如：http://www.abc.com/wechat/index/serve', '0', '0', '2'), ('234', 'paydir', 'textarea', '4', '', '0', '', '100', '5', '', '配置目录', '支付目录配置系统不调用提示作用', '0', '1', '2'), ('235', 'pay_routine_mchid', 'text', '14', '', '0', 'required:true', '100', '0', '', 'Mchid', '商户号', '0', '1', '2'), ('236', 'pay_routine_key', 'text', '14', '', '0', 'required:true', '100', '0', '', 'Key', '商户key', '0', '1', '2'), ('237', 'smsSignName', 'text', '1', null, null, '', '100', null, '', '阿里云短信签名', '阿里云短信签名', '0', '1', '2'), ('238', 'accessKeyId', 'text', '1', null, null, '', '100', null, '', '阿里云短信AccessKeyId', '阿里云短信AccessKeyId', '0', '1', '2'), ('239', 'accessKeySecret', 'text', '1', null, null, '', '100', null, '', '阿里云短信AccessKeySecret', '阿里云短信AccessKeySecret', '0', '1', '2'), ('240', 'smsTemplateCode', 'text', '1', null, null, '', '100', null, '', '阿里云短信模板ID', '阿里云短信模板ID', '0', '1', '2'), ('241', 'access_key_id', 'text', '1', null, null, '', '100', null, '', '金山云ACCESS KEY ID', '金山云ACCESS KEY ID', '0', '1', '2'), ('242', 'access_sk', 'text', '1', null, null, '', '100', null, '', '金山云SK', '金山云SK', '0', '1', '2'), ('243', 'alipay_app_id', 'text', '4', null, null, '', '100', null, '', '蚂蚁金服appid', '蚂蚁金服appid', '0', '1', '2'), ('244', 'alipay_private_key', 'text', '4', null, null, '', '100', null, '', '蚂蚁金服key', '蚂蚁金服key', '0', '1', '2'), ('245', 'alipay_public_key', 'text', '4', null, null, '', '100', null, '', '蚂蚁金服公钥', '蚂蚁金服公钥', '0', '1', '2'), ('246', 'site_phone', 'text', '1', '', '0', '', '100', '0', '', '联系电话', '联系电话', '0', '1', '3'), ('247', 'site_email', 'text', '1', '', '0', 'email:true', '100', '0', '', '联系邮箱', '联系邮箱', '0', '1', '3'), ('248', 'site_qq', 'text', '1', '', '0', 'qq:true', '100', '0', '', '联系QQ', '联系QQ', '0', '1', '3'), ('249', 'wechat_name', 'text', '2', '', '0', 'required:true', '100', '0', '\"\\u5706\\u6e90\\u6587\\u5316\\u5de5\\u4f5c\\u5ba4\"', '公众号名称', '公众号的名称', '0', '1', '3'), ('250', 'wechat_id', 'text', '2', '', '0', 'required:true', '100', '0', '\"\\u5706\\u6e90\\u6587\\u5316\\u5de5\\u4f5c\\u5ba4\"', '微信号', '微信号', '0', '1', '3'), ('251', 'wechat_sourceid', 'text', '2', '', '0', 'required:true', '100', '0', '\"gh_72ecde546df1\"', '公众号原始id', '公众号原始id', '0', '1', '3'), ('252', 'wechat_appid', 'text', '2', '', '0', 'required:true', '100', '0', '\"wxd03a5f945f5594ee\"', 'AppID', 'AppID', '0', '1', '3'), ('253', 'wechat_appsecret', 'text', '2', '', '0', 'required:true', '100', '0', '\"9e3dfe15502f097fe2cc58e75846307c\"', 'AppSecret', 'AppSecret', '0', '1', '3'), ('254', 'wechat_token', 'text', '2', '', '0', 'required:true', '100', '0', '\"4f17e5e8dc5705da4faa2adef70862fd\"', '微信验证TOKEN', '微信验证TOKEN', '0', '1', '3'), ('255', 'wechat_encode', 'radio', '2', '0=明文模式\n1=兼容模式\n2=安全模式', '0', '', '0', '0', '\"0\"', '消息加解密方式', '如需使用安全模式请在管理中心修改，仅限服务号和认证订阅号', '0', '1', '3'), ('256', 'wechat_encodingaeskey', 'text', '2', '', '0', 'required:true', '100', '0', '\"nT4mAfLsi0MrrPfBcmbwqCRXBYOdJGzcIWHQiAyPrrC\"', 'EncodingAESKey', '公众号消息加解密Key,在使用安全模式情况下要填写该值，请先在管理中心修改，然后填写该值，仅限服务号和认证订阅号', '0', '1', '3'), ('257', 'wechat_share_img', 'upload', '2', '', '1', '', '0', '0', '\"\"', '微信分享图片', '若填写此图片地址，则分享网页出去时会分享此图片。可有效防止分享图片变形', '0', '1', '3'), ('258', 'wechat_qrcode', 'upload', '2', '', '1', '', '0', '0', '\"\"', '公众号二维码', '您的公众号二维码', '0', '1', '3'), ('259', 'wechat_type', 'radio', '2', '0=服务号\n1=订阅号', '0', '', '0', '0', '\"0\"', '公众号类型', '公众号的类型', '0', '1', '3'), ('260', 'wechat_share_title', 'text', '2', '', '0', 'required:true', '100', '0', '\"\\u5706\\u6e90\\u5de5\\u4f5c\\u5ba4\"', '微信分享标题', '微信分享标题', '0', '1', '3'), ('261', 'wechat_share_synopsis', 'textarea', '2', '', '0', '', '100', '5', '\"\"', '微信分享简介', '微信分享简介', '0', '1', '3'), ('262', 'pay_weixin_appid', 'text', '4', '', '0', '', '100', '0', '', 'Appid', '微信公众号身份的唯一标识。审核通过后，在微信发送的邮件中查看。', '0', '1', '3'), ('263', 'pay_weixin_appsecret', 'text', '4', '', '0', '', '100', '0', '', 'Appsecret', 'JSAPI接口中获取openid，审核后在公众平台开启开发模式后可查看。', '0', '1', '3'), ('264', 'pay_weixin_mchid', 'text', '4', '', '0', '', '100', '0', '', 'Mchid', '受理商ID，身份标识', '0', '1', '3'), ('265', 'pay_weixin_client_cert', 'upload', '4', '', '3', '', '0', '0', '', '微信支付证书', '微信支付证书，在微信商家平台中可以下载！文件名一般为apiclient_cert.pem', '0', '1', '3'), ('266', 'pay_weixin_client_key', 'upload', '4', '', '3', '', '0', '0', '', '微信支付证书密钥', '微信支付证书密钥，在微信商家平台中可以下载！文件名一般为apiclient_key.pem', '0', '1', '3'), ('267', 'pay_weixin_key', 'text', '4', '', '0', '', '100', '0', '', 'Key', '商户支付密钥Key。审核通过后，在微信发送的邮件中查看。', '0', '1', '3'), ('268', 'site_service_phone', 'text', '1', '', '0', '', '100', '0', '', '客服电话', '客服联系电话', '0', '1', '3'), ('269', 'api', 'text', '2', '', '0', '', '100', '0', '\"\\/wechat\\/index\\/serve\"', '接口地址', '保持默认，谨慎修改。微信接口例如：http://www.abc.com/wechat/index/serve', '0', '0', '3'), ('270', 'paydir', 'textarea', '4', '', '0', '', '100', '5', '', '配置目录', '支付目录配置系统不调用提示作用', '0', '1', '3'), ('271', 'pay_routine_mchid', 'text', '14', '', '0', 'required:true', '100', '0', '', 'Mchid', '商户号', '0', '1', '3'), ('272', 'pay_routine_key', 'text', '14', '', '0', 'required:true', '100', '0', '', 'Key', '商户key', '0', '1', '3'), ('273', 'smsSignName', 'text', '1', null, null, '', '100', null, '', '阿里云短信签名', '阿里云短信签名', '0', '1', '3'), ('274', 'accessKeyId', 'text', '1', null, null, '', '100', null, '', '阿里云短信AccessKeyId', '阿里云短信AccessKeyId', '0', '1', '3'), ('275', 'accessKeySecret', 'text', '1', null, null, '', '100', null, '', '阿里云短信AccessKeySecret', '阿里云短信AccessKeySecret', '0', '1', '3'), ('276', 'smsTemplateCode', 'text', '1', null, null, '', '100', null, '', '阿里云短信模板ID', '阿里云短信模板ID', '0', '1', '3'), ('277', 'access_key_id', 'text', '1', null, null, '', '100', null, '', '金山云ACCESS KEY ID', '金山云ACCESS KEY ID', '0', '1', '3'), ('278', 'access_sk', 'text', '1', null, null, '', '100', null, '', '金山云SK', '金山云SK', '0', '1', '3'), ('279', 'alipay_app_id', 'text', '4', null, null, '', '100', null, '', '蚂蚁金服appid', '蚂蚁金服appid', '0', '1', '3'), ('280', 'alipay_private_key', 'text', '4', null, null, '', '100', null, '', '蚂蚁金服key', '蚂蚁金服key', '0', '1', '3'), ('281', 'alipay_public_key', 'text', '4', null, null, '', '100', null, '', '蚂蚁金服公钥', '蚂蚁金服公钥', '0', '1', '3');
COMMIT;

-- ----------------------------
--  Table structure for `eb_system_config_tab`
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_config_tab`;
CREATE TABLE `eb_system_config_tab` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置分类id',
  `title` varchar(255) NOT NULL COMMENT '配置分类名称',
  `eng_title` varchar(255) NOT NULL COMMENT '配置分类英文名称',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '配置分类状态',
  `info` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '配置分类是否显示',
  `icon` varchar(30) DEFAULT NULL COMMENT '图标',
  `type` int(2) DEFAULT '0' COMMENT '配置类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='配置分类表';

-- ----------------------------
--  Records of `eb_system_config_tab`
-- ----------------------------
BEGIN;
INSERT INTO `eb_system_config_tab` VALUES ('1', '系统配置', 'sys_cfg', '1', '0', null, '0'), ('2', '微信配置', 'wechat_cfg', '1', '0', null, '0'), ('4', '支付配置', 'pay_cfg', '1', '0', null, '0');
COMMIT;

-- ----------------------------
--  Table structure for `eb_system_log`
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_log`;
CREATE TABLE `eb_system_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员操作记录ID',
  `admin_id` int(10) unsigned NOT NULL COMMENT '管理员id',
  `admin_name` varchar(64) NOT NULL COMMENT '管理员姓名',
  `path` varchar(128) NOT NULL COMMENT '链接',
  `page` varchar(64) NOT NULL COMMENT '行为',
  `method` varchar(12) NOT NULL COMMENT '访问类型',
  `ip` varchar(16) NOT NULL COMMENT '登录IP',
  `type` varchar(32) NOT NULL COMMENT '类型',
  `add_time` int(10) unsigned NOT NULL COMMENT '操作时间',
  `merchant_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商户id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `admin_id` (`admin_id`) USING BTREE,
  KEY `add_time` (`add_time`) USING BTREE,
  KEY `type` (`type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员操作记录表';

-- ----------------------------
--  Table structure for `eb_system_menus`
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_menus`;
CREATE TABLE `eb_system_menus` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `pid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
  `icon` varchar(16) NOT NULL COMMENT '图标',
  `menu_name` varchar(32) NOT NULL DEFAULT '' COMMENT '按钮名',
  `module` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '模块名',
  `controller` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '控制器',
  `action` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '方法名',
  `params` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '[]' COMMENT '参数',
  `sort` tinyint(3) NOT NULL DEFAULT '1' COMMENT '排序',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示',
  `access` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '子管理员是否可用',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE,
  KEY `is_show` (`is_show`) USING BTREE,
  KEY `access` (`access`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=466 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='菜单表';

-- ----------------------------
--  Records of `eb_system_menus`
-- ----------------------------
BEGIN;
INSERT INTO `eb_system_menus` VALUES ('2', '153', '', '权限规则', 'admin', 'setting.systemMenus', 'index', '{\"cate\":\"12\"}', '7', '1', '1'), ('4', '153', '', '管理员列表', 'admin', 'setting.systemAdmin', 'index', '[]', '9', '1', '1'), ('8', '153', '', '身份管理', 'admin', 'setting.systemRole', 'index', '[]', '10', '1', '1'), ('21', '0', 'magic', '系统维护', 'admin', 'system.system', '', '[]', '1', '1', '1'), ('130', '21', '', '系统日志', 'admin', 'system.systemLog', 'index', '[]', '5', '1', '1'), ('151', '0', 'user', '会员管理', 'admin', 'user.userList', 'list', '[]', '126', '1', '1'), ('153', '289', '', '管理权限', 'admin', 'setting.systemAdmin', '', '[]', '100', '1', '1'), ('177', '151', '', '会员列表', 'admin', 'user.user', 'index', '[]', '10', '1', '1'), ('237', '21', '', '刷新缓存', 'admin', 'system.clear', 'index', '[]', '0', '1', '1'), ('287', '0', 'money', '财务管理', 'admin', '', '', '[]', '3', '1', '1'), ('289', '0', 'gear', '系统配置', 'admin', '', '', '[]', '1', '1', '1'), ('374', '295', '', '分销会员业务', 'admin', 'record.record', 'user_distribution_chart', '[]', '0', '1', '1'), ('422', '0', 'coffee', '日常维护', 'admin', '', '', '[]', '90', '1', '1'), ('427', '422', '', '首页轮播', 'admin', 'maintain.banner', 'index', '[]', '0', '1', '1'), ('433', '0', 'mortar-board', '基础数据', 'admin', '', '', '[]', '125', '1', '1'), ('435', '433', '', '店铺管理', 'admin', 'supervision.school', 'index', '[]', '10', '1', '1'), ('437', '287', '', '财务事项汇总', 'admin', 'financial.statistic', 'review', '[]', '0', '1', '1'), ('443', '0', 'leanpub', '技师管理', 'admin', 'teachaffair.teacher', 'index', '[]', '124', '1', '1'), ('444', '0', 'steam', '单据管理', 'admin', '', '', '[]', '124', '1', '1'), ('446', '444', '', '消费订单', 'admin', 'financial.order', 'consume', '[]', '0', '1', '1'), ('449', '433', '', '品牌管理', 'admin', 'teachaffair.organ', 'index', '[]', '100', '1', '1'), ('453', '422', '', '文本管理', 'admin', 'maintain.article_category', 'index', '[]', '0', '1', '1'), ('456', '422', '', '热门搜索', 'admin', 'maintain.hotsearch', 'index', '[]', '0', '1', '1'), ('457', '287', '', '微信提现', 'admin', 'financial.withdraw', 'wechat', '[]', '0', '1', '1'), ('458', '433', '', '服务管理', 'admin', 'service.service', 'index', '[]', '0', '1', '1'), ('459', '433', '', '商品管理', 'admin', 'goods.goods', 'index', '[]', '0', '1', '1'), ('460', '433', '', '套餐管理', 'admin', 'package.package', 'index', '[]', '0', '1', '1'), ('461', '151', '', '会员等级', 'admin', 'user.user_level', 'index', '[]', '0', '1', '1'), ('462', '0', 'money', '收银结账', 'admin', 'financial.consume', 'checkout', '[]', '127', '1', '1'), ('463', '444', '', '充值记录', 'admin', 'financial.order', 'recharge', '[]', '0', '1', '1'), ('464', '444', '', '退卡记录', 'admin', 'financial.order', 'refund_card', '[]', '0', '1', '1'), ('465', '444', '', '退套餐记录', 'admin', 'financial.order', 'refund_package', '[]', '0', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `eb_system_role`
-- ----------------------------
DROP TABLE IF EXISTS `eb_system_role`;
CREATE TABLE `eb_system_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '身份管理id',
  `role_name` varchar(32) NOT NULL COMMENT '身份管理名称',
  `rules` text NOT NULL COMMENT '身份管理权限(menus_id)',
  `level` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='身份管理表';

-- ----------------------------
--  Records of `eb_system_role`
-- ----------------------------
BEGIN;
INSERT INTO `eb_system_role` VALUES ('26', '品牌管理员', '462,151,177,461,433,449,435,458,459,460,444,446,463,464,465,443,422,427,453,456,287,437,457', '1', '1'), ('27', '校区管理账号-财务版', '462,151,177,461,433,449,435,458,459,460,444,446,463,464,465,443,287,437,457', '1', '1'), ('28', '校区管理账号-非财务版', '422,427,453,456,444,446,442,443,440,434,447,451,454,450,436,0,433,445', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `eb_teacher_info`
-- ----------------------------
DROP TABLE IF EXISTS `eb_teacher_info`;
CREATE TABLE `eb_teacher_info` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `full_name` varchar(60) DEFAULT '',
  `avatar` varchar(255) DEFAULT '' COMMENT '头像',
  `mobile` varchar(30) DEFAULT '',
  `school_id` int(10) unsigned DEFAULT '0' COMMENT '校区ID',
  `is_del` int(10) unsigned DEFAULT '0',
  `org_id` int(10) unsigned DEFAULT '0',
  `status` tinyint(1) unsigned DEFAULT '1',
  `title` varchar(50) DEFAULT '' COMMENT '职务',
  `level` varchar(50) DEFAULT '' COMMENT '级别',
  `skills` varchar(120) DEFAULT '' COMMENT '擅长技能',
  `experience` varchar(120) DEFAULT '' COMMENT '从业年限',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `oid` (`org_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='技师表';

-- ----------------------------
--  Records of `eb_teacher_info`
-- ----------------------------
BEGIN;
INSERT INTO `eb_teacher_info` VALUES ('1', '张嘟嘟', '{\"key\":\"basic_cover\\/16296067047186.jpg\",\"pic\":\"https:\\/\\/ks3-cn-beijing.ksyun.com\\/teaseyoulearn\\/basic_cover\\/16296067047186.jpg\"}', '13811652323', '9', '0', '1', '1', '副店长', '高级按摩师', '推拿，按摩', '从业15年');
COMMIT;

-- ----------------------------
--  Table structure for `eb_user`
-- ----------------------------
DROP TABLE IF EXISTS `eb_user`;
CREATE TABLE `eb_user` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `pwd` char(40) NOT NULL COMMENT '用户密码',
  `avatar` varchar(256) NOT NULL COMMENT '用户头像',
  `mobile` char(11) NOT NULL DEFAULT '' COMMENT '手机号码',
  `full_name` varchar(35) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '真实姓名',
  `add_time` int(11) unsigned NOT NULL COMMENT '添加时间',
  `add_ip` varchar(16) NOT NULL COMMENT '添加ip',
  `last_time` int(11) unsigned NOT NULL COMMENT '最后一次登录时间',
  `gift_money` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '赠送金额',
  `last_ip` varchar(16) NOT NULL COMMENT '最后一次登录ip',
  `now_money` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '用户余额',
  `integral` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '用户剩余积分',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1为正常，0为禁止',
  `level_id` smallint(2) unsigned NOT NULL DEFAULT '0' COMMENT '等级',
  `spread_uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '推广元id',
  `spread_time` int(11) NOT NULL DEFAULT '0',
  `user_type` varchar(10) NOT NULL DEFAULT '' COMMENT '用户类型',
  `is_promoter` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为推广员',
  `salt` varchar(6) DEFAULT '' COMMENT '密码加盐',
  `remark` varchar(255) DEFAULT '' COMMENT '备注',
  `register_date` datetime DEFAULT NULL COMMENT '开卡日期',
  `gender` tinyint(1) unsigned DEFAULT '0' COMMENT '性别：【0保密 1男 2女】',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '机构ID',
  `school_id` int(10) unsigned DEFAULT '0',
  `is_del` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `spreaduid` (`spread_uid`) USING BTREE,
  KEY `level` (`level_id`) USING BTREE,
  KEY `status` (`status`) USING BTREE,
  KEY `is_promoter` (`is_promoter`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
--  Records of `eb_user`
-- ----------------------------
BEGIN;
INSERT INTO `eb_user` VALUES ('1', 'dfa616fbe9eb229121ddc1b393918d7e1a49e235', '', '136', '周芷若', '1630249747', '127.0.0.1', '0', '900.00', '', '9000.00', '0.00', '1', '2', '0', '0', '', '0', 'xAoO91', '', '2021-08-29 23:09:03', '0', '1', '7', '0');
COMMIT;

-- ----------------------------
--  Table structure for `eb_user_bill`
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_bill`;
CREATE TABLE `eb_user_bill` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户账单id',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户uid',
  `order_id` int(10) NOT NULL DEFAULT '0' COMMENT '关联id',
  `title` varchar(64) NOT NULL DEFAULT '' COMMENT '账单标题',
  `type` varchar(64) NOT NULL DEFAULT '' COMMENT '明细类型',
  `amt` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '明细数字',
  `balance` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '剩余',
  `mark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `add_time` datetime NOT NULL COMMENT '添加时间',
  `category` tinyint(2) unsigned DEFAULT '0' COMMENT '对应的订单类别',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `openid` (`uid`) USING BTREE,
  KEY `add_time` (`add_time`) USING BTREE,
  KEY `type` (`type`,`order_id`) USING BTREE,
  KEY `cid` (`category`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户账单表';

-- ----------------------------
--  Records of `eb_user_bill`
-- ----------------------------
BEGIN;
INSERT INTO `eb_user_bill` VALUES ('1', '1', '1', '开卡充值', 'now_money', '5000.00', '5000.00', '', '2021-08-29 23:09:07', '4'), ('2', '1', '1', '开卡赠送', 'gift_money', '500.00', '500.00', '', '2021-08-29 23:09:07', '4'), ('3', '1', '2', '充值', 'now_money', '4000.00', '9000.00', '', '2021-08-29 23:15:59', '2'), ('4', '1', '2', '充值赠送', 'gift_money', '400.00', '900.00', '', '2021-08-29 23:15:59', '2');
COMMIT;

-- ----------------------------
--  Table structure for `eb_user_level`
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_level`;
CREATE TABLE `eb_user_level` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `level_name` varchar(120) DEFAULT '' COMMENT '等级名称',
  `discount` tinyint(3) unsigned DEFAULT '0' COMMENT '折扣（0-100）',
  `expire_type` tinyint(1) unsigned DEFAULT '1' COMMENT '有效期类型【1：永久 2：指定日期】',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间【expire_type为2时有值】',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态【1：有效 2：过期 3：禁用】',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '所属机构',
  `school_id` int(10) unsigned DEFAULT '0' COMMENT '所属分店',
  `is_del` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mix` (`org_id`,`school_id`,`is_del`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户等级表';

-- ----------------------------
--  Records of `eb_user_level`
-- ----------------------------
BEGIN;
INSERT INTO `eb_user_level` VALUES ('1', '黄金', '80', '2', '2021-08-29 23:07:20', '1', '1', '7', '0'), ('2', '钻石', '60', '1', '0000-00-00 00:00:00', '1', '1', '7', '0'), ('3', '大众会员', '95', '1', '0000-00-00 00:00:00', '1', '1', '14', '0');
COMMIT;

-- ----------------------------
--  Table structure for `eb_user_recharge`
-- ----------------------------
DROP TABLE IF EXISTS `eb_user_recharge`;
CREATE TABLE `eb_user_recharge` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL COMMENT '充值用户UID',
  `level_id` smallint(5) NOT NULL DEFAULT '0' COMMENT '会员等级ID',
  `order_id` int(10) unsigned DEFAULT '0' COMMENT '订单ID',
  `now_money` decimal(8,2) DEFAULT NULL COMMENT '充值金额',
  `gift_money` decimal(8,2) DEFAULT NULL COMMENT '赠送金额',
  `status` tinyint(1) unsigned DEFAULT '0' COMMENT '状态【1：有效】',
  `pay_time` datetime DEFAULT NULL COMMENT '充值支付时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `order_date` date DEFAULT NULL COMMENT '单据日期',
  `org_id` int(10) unsigned DEFAULT '0',
  `school_id` int(10) unsigned DEFAULT '0',
  `is_del` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `order_id` (`order_id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE,
  KEY `mix` (`org_id`,`school_id`,`is_del`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户充值表';

-- ----------------------------
--  Records of `eb_user_recharge`
-- ----------------------------
BEGIN;
INSERT INTO `eb_user_recharge` VALUES ('1', '1', '2', '2', '4000.00', '400.00', '1', '2021-08-29 23:15:59', '2021-08-29 23:15:59', '2021-08-29', '1', '7', '0');
COMMIT;

-- ----------------------------
--  Table structure for `eb_withdraw`
-- ----------------------------
DROP TABLE IF EXISTS `eb_withdraw`;
CREATE TABLE `eb_withdraw` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `amount` decimal(14,2) unsigned DEFAULT '0.00' COMMENT '提现金额',
  `wd_type` enum('wechat','alipay','bank') DEFAULT 'wechat' COMMENT '提现类型',
  `create_time` datetime DEFAULT NULL COMMENT '提交时间',
  `audit_time` datetime DEFAULT NULL COMMENT '审核时间',
  `receipt_time` datetime DEFAULT NULL COMMENT '到账时间',
  `receipt_account` varchar(40) DEFAULT '' COMMENT '到账账号（微信昵称，支付宝昵称，或银行卡号，冗余字段）',
  `audit_type` tinyint(1) unsigned DEFAULT '0' COMMENT '审核类型：1系统，2人工',
  `audit_user` varchar(40) DEFAULT '' COMMENT '审核人（SYSTEM或管理员名称）',
  `status` tinyint(5) unsigned DEFAULT '0' COMMENT '状态（1：提交待审核 2：已审核 3：已付款 4：提现失败）',
  `s4_reason` varchar(120) DEFAULT NULL COMMENT '状态4提现失败的原因',
  `org_id` int(10) unsigned DEFAULT '0' COMMENT '机构ID',
  `is_del` int(10) unsigned DEFAULT '0',
  `transaction_seq` varchar(40) DEFAULT '' COMMENT '交易序列号',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `dft` (`org_id`,`is_del`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='提现申请表';

-- ----------------------------
--  Records of `eb_withdraw`
-- ----------------------------
BEGIN;
INSERT INTO `eb_withdraw` VALUES ('1', '1.00', 'wechat', '2021-07-07 23:46:47', '2021-07-07 23:57:43', '2021-07-07 23:57:43', 'oKqF7w3RZoyWMQ_9PFP-SV6KnBP4', '1', 'SYSTEM', '3', null, '1', '0', 'WX202107072357428505'), ('2', '1.00', 'wechat', '2021-07-08 09:37:19', '2021-07-08 09:42:02', '2021-07-08 09:42:02', 'oKqF7w3RZoyWMQ_9PFP-SV6KnBP4', '1', 'SYSTEM', '3', null, '1', '0', 'WX202107080942019067'), ('3', '5000.00', 'wechat', '2021-07-08 17:41:50', '2021-07-08 17:42:03', '2021-07-08 17:42:03', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107081742013255'), ('4', '5000.00', 'wechat', '2021-07-08 17:42:31', '2021-07-08 17:45:02', null, 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '4', '支付失败', '2', '0', 'WX202107081745012153'), ('5', '5000.00', 'wechat', '2021-07-08 17:43:05', '2021-07-08 17:45:02', null, 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '4', '支付失败', '2', '0', 'WX202107081745022892'), ('6', '5000.00', 'wechat', '2021-07-09 19:48:29', '2021-07-09 19:51:02', '2021-07-09 19:51:02', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107091951012441'), ('7', '5000.00', 'wechat', '2021-07-09 19:48:47', '2021-07-09 19:51:02', null, 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '4', '支付失败', '2', '0', 'WX202107091951027067'), ('8', '5000.00', 'wechat', '2021-07-10 17:45:09', '2021-07-10 17:48:03', '2021-07-10 17:48:03', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107101748026134'), ('9', '5000.00', 'wechat', '2021-07-11 18:12:53', '2021-07-11 18:15:02', '2021-07-11 18:15:02', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107111815013139'), ('10', '5000.00', 'wechat', '2021-07-12 18:56:29', '2021-07-12 18:57:03', '2021-07-12 18:57:03', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107121857016092'), ('11', '5000.00', 'wechat', '2021-07-14 13:26:53', '2021-07-14 13:27:03', '2021-07-14 13:27:03', 'oKqF7w08DC0k_V8zG3brgb2RFkJA', '1', 'SYSTEM', '3', null, '3', '0', 'WX202107141327023354'), ('12', '5000.00', 'wechat', '2021-07-14 13:27:13', '2021-07-14 13:30:02', null, 'oKqF7w08DC0k_V8zG3brgb2RFkJA', '1', 'SYSTEM', '4', '支付失败', '3', '0', 'WX202107141330016763'), ('13', '5000.00', 'wechat', '2021-07-14 13:27:20', '2021-07-14 13:30:02', null, 'oKqF7w08DC0k_V8zG3brgb2RFkJA', '1', 'SYSTEM', '4', '支付失败', '3', '0', 'WX202107141330021566'), ('14', '5000.00', 'wechat', '2021-07-14 14:44:37', '2021-07-14 14:45:02', '2021-07-14 14:45:02', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107141445014876'), ('15', '5000.00', 'wechat', '2021-07-15 18:05:57', '2021-07-15 18:06:02', '2021-07-15 18:06:02', 'oKqF7w08DC0k_V8zG3brgb2RFkJA', '1', 'SYSTEM', '3', null, '3', '0', 'WX202107151806014039'), ('16', '5000.00', 'wechat', '2021-07-15 18:06:53', '2021-07-15 18:09:01', null, 'oKqF7w08DC0k_V8zG3brgb2RFkJA', '1', 'SYSTEM', '4', '支付失败', '3', '0', 'WX202107151809018198'), ('17', '5000.00', 'wechat', '2021-07-16 09:36:17', '2021-07-16 09:39:02', '2021-07-16 09:39:02', 'oKqF7w08DC0k_V8zG3brgb2RFkJA', '1', 'SYSTEM', '3', null, '3', '0', 'WX202107160939016694'), ('18', '5000.00', 'wechat', '2021-07-16 18:28:34', '2021-07-16 18:30:02', '2021-07-16 18:30:02', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107161830014144'), ('19', '5000.00', 'wechat', '2021-07-17 18:56:17', '2021-07-17 18:57:02', '2021-07-17 18:57:02', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107171857011680'), ('20', '5000.00', 'wechat', '2021-07-18 20:24:20', '2021-07-18 20:27:02', '2021-07-18 20:27:02', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107182027017051'), ('21', '5000.00', 'wechat', '2021-07-20 17:43:52', '2021-07-20 17:45:02', '2021-07-20 17:45:02', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107201745017965'), ('22', '5000.00', 'wechat', '2021-07-21 23:09:01', '2021-07-21 23:09:02', '2021-07-21 23:09:02', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107212309018345'), ('23', '5000.00', 'wechat', '2021-07-22 20:48:52', '2021-07-22 20:51:03', '2021-07-22 20:51:03', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1', 'SYSTEM', '3', null, '2', '0', 'WX202107222051028610');
COMMIT;

-- ----------------------------
--  Table structure for `eb_withdraw_account`
-- ----------------------------
DROP TABLE IF EXISTS `eb_withdraw_account`;
CREATE TABLE `eb_withdraw_account` (
  `org_id` int(10) unsigned NOT NULL,
  `wd_type` enum('wechat','alipay','bank') NOT NULL DEFAULT 'wechat' COMMENT '提现账号类型',
  `wd_reciver_name` varchar(40) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '提现人昵称',
  `wd_reciver_realname` varchar(40) DEFAULT '' COMMENT '提现人真实姓名',
  `wd_reciver_account` varchar(255) DEFAULT '' COMMENT '提现人账号（wechat:openid）',
  `is_valid` tinyint(3) unsigned DEFAULT '0' COMMENT '账号是否有效',
  PRIMARY KEY (`org_id`,`wd_type`) USING BTREE,
  UNIQUE KEY `wd_type` (`wd_type`,`wd_reciver_account`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='机构提现账号';

-- ----------------------------
--  Records of `eb_withdraw_account`
-- ----------------------------
BEGIN;
INSERT INTO `eb_withdraw_account` VALUES ('1', 'wechat', 'Pony', '方伟', 'oKqF7w3RZoyWMQ_9PFP-SV6KnBP4', '1'), ('2', 'wechat', '安安', '张瑞瑞', 'oKqF7w34NMvhlHaanSzy_1qN4kUk', '1'), ('3', 'wechat', '妙敏', '陆晓敏', 'oKqF7w08DC0k_V8zG3brgb2RFkJA', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
